Copy to Dynamic Column

[Len55]

Hi,

Row 5 can be dynamic, the last column in Row 5 can be different

In Sheet 2, I want to copy A6:B17 then auto fill C6: this is were I am getting into trouble, how can I paste to the last column used, this defined by the last cell used in row 5.

For example, AB5 is the last cell.

I would then want to auto fill C6:AB6

BZ5 is the last cell.

I would then want to auto fill C6:BZ6

Any help appreciated.

Len55

[protonLeah]

req deleted

[MarvinP]

Hi Lens

Using some VBA code the last used cell in Row5 is:

LastCol = Cells(5,Columns.Count).End(xlToLeft).Column
Cells(5,LastCol).Select

The above two lines will put your cursor in the last column in row 5 that has data in it.
It is the same as going to a cell beyond your data (to the right) in row 5 and pressing Ctrl+Left Arrow.

Read this link for more:
http://spreadsheetpage.com/index.php...e_size_ranges/

[Len55]

Hi Marvinp,

Thanks, unfortunately I do not know that much about VBa, is it possible to be able to put the code into the scenario I am after'

Thank