Help with copying to last column

[snuffnchess]

I have a data set that does not always have info in column M, and when data copies, it stops at Column L when this happens... and i need it to go to the last column.

The issue i know is in line

Please Login or Register  to view this content.

I have the last column defined earlier as "lcol = Cells(2, Columns.Count).End(xlToLeft).Column"

How do I sub in that lcol variable into the rg equation without messing everything up???

[Eastw00d]

Hi, what if you would do the following:

Please Login or Register  to view this content.

Cheers
Erwin

[snuffnchess]

Hi, what if you would do the following:

Please Login or Register  to view this content.

Cheers
Erwin

Hi Erwin.... That is almost perfect.

When that runs, it is capturing what is in column A, and that needs to to happen. It is also not bringing over the header row for the data set.

[Eastw00d]

Yes, you can leave than the offset(1) part out, but with this you can find the limits of your range, like

Please Login or Register  to view this content.

so you can set these variables to your own needs and set for example a new range:

Please Login or Register  to view this content.

Cheers
Erwin

[snuffnchess]

Sorry for not replying sooner! Just updated the code, and with a slight tweak to what you posted, it worked perfectly!

Just removed the +1 from FirstRow and put it on the Lastrow

Please Login or Register  to view this content.