I have a sheet that has a dynamic range and I need to paste copied data starting 1 row down from the last row in that range so I can continually keep adding data to this sheet.
This is the line I am having difficultly with. And I am guessing that it is the last bit of the code that is not working. The last bit of code works fine when a hard code the range to be "B2" instead of "B" & LastRw + 1
Note:I am copying from a dynamic range , hence the "lastRw" in the first part of the code.
LastRw is set as this code,
Cheers
Bookmarks