Hi!
I would like to copy an area that varies in rows. So lastrow in my code is the last populated row and I would want to copy everything from the cell B6 to this last row and the nine columns next to it.
How could I do this correctly?
This is my code that is not yet working
Thanks for your help!
I would like to copy an area that varies in rows. So lastrow in my code is the last populated row and I would want to copy everything from the cell B6 to this last row and the nine columns next to it.
How could I do this correctly?
This is my code that is not yet working
Code:
Range(("B6" & LastRow&Offset(0,9)).Copy Destination:=Sheets(myvalue)
Thanks for your help!