Dynamic Range
Hi Arnie
Try this:
FirstCell = "L3"
LastCell = Range("A3").End(xlDown).Offset(-1, 0).Address
Range(FirstCell, LastCell).Copy
Regards,
Per
"Arnie" skrev i meddelelsen
...
I have a dynamic range which i use
Range("A3").End(xlDown).Offset(-1, 0).Select
to find the last cell with data in.
Then i use ActiveCell.Resize(1, 12).Select to select across to column L
What i can't seem to do is select up from ActiveCell in this case A363
(this
is dynamic) to L363 to A3:L3 (this range is then required to be copied)
Any help would be appreciated
Thanks in advance
Arnie
|