I am looking for a way to take the current sheet's headers and footers and apply them to all other sheets. Simply selecting all the sheets I want does not work because it applies ALL page setup settings to all the sheets, including print area, margins, and so forth.
I want only the header and footer to apply to all sheets. I had an idea as follows:
Please Login or Register to view this content.
There are obvious things wrong with this code, but I don't know how to get around it. Any help on how to solve this problem is greatly appreciated!
Bookmarks