Copy named range "headerrows" to each worksheet as created by named range "classes"

The below code works to create worksheets from a dynamic named range "classes". I am trying to add header rows, another named range, as the worksheet is created. The macro does copy the named range "headerrows" but doesn't paste even though the worksheet is correctly named and created.

Any ideas how to properly reference the newly created worksheet??

Please Login or Register  to view this content.

Hi,

First I suggest you remove the On Error Resume Next line as it is simply masking whatever the problem is. Then run the code again, but first change this line

Please Login or Register  to view this content.

to remove the .PasteSpecial part since the destination argument should be a range object.

Sorry- lack of coffee. That should of course read

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.