destcell

  1. rjplante

    transfer data with resize

    I am trying to move data from my active worksheet to a destination worksheet without using specific named ranges. When I run the code below, I get the following error: "Run-Time error '438': Object doesn't support this property or method." The line with my resize text is the line of text...
  2. M

    VBA Copy and Transpose to merged cells

    Hi This code is working but only copying 2 rows down instead of grabbing all till last data row? I think it's to do with the offset or the columns /rows set but don't know how to solve? Sub TransposeToMergedCells() Dim StartCell As Range Dim DestCell As Range Set StartCell =...
  3. T

    Delete contents prior to import

    Hi, I have created an import for a CSV fil, which is working fine - apart from the issue I am facing where the contents being imported are being added to the list already present, I need this to amend the entire range, so to delete the information held with in the sheet (starting from row 10)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top