Laurence -
When the Worksheet.Copy() method was first released (thanks again) there was a bug that Page Formatting options (like locking a certain number of rows as a “header”) were not copied. This was fixed in a hotfix or 2 later. However, now it seems that bug has resurfaced. Any thoughts?
I didn’t make any changes in Copy method after I fixed the page formatting issue. So I think this problem is a new bug. Could you send me an email to elaborate your problem? And please attach your file and code if possible. Thanks.
It’s fixed. A new hotfix will be released within one or two days.