Dynamic range fails to copy correctly to new workbook

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.

You need to determine the last row BEFORE you create your new workbook (because that becomes the Active Workbook)

Try it this way

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.