Hi Charlize! And thanks for the help. :D
I gave this a try and received a couple runtime errors, I took out the lines that were giving me trouble, such as creating page breaks; useful but not required.
Now I've encountered a different type of problem.In the Excel document I have some cells in Column A merged, in most of the pages this carries over with the pasting macro but about half way through it stops, is ok for one worksheet/page, and then stops again.
Would you happen to know what causes this? I've ran the macro several times and it's consistantly wrong on the same worksheets. Is it something in my Excel worksheets, formatting, etc since it works on some pages and not others?
Bookmarks