Hi all,
New to VBA and trying to practice a bit by creating a calendar, but struggling to copy a dynamic range to the new workbook. If I copy to H4:I20 it works fine, but I don't know how many rows will be populated and hence want this to be dynamic.
I'm using LastRow to count to the last row and then trying to use that to copy only the rows that are populated.
I feel like I'm missing something very silly and any help would be greatly appreciated.
Thanks in advance!
Please Login or Register to view this content.
Bookmarks