By Allen Wyatt for Excel.Tips.Net
If you have a large worksheet, you may want to print it out in “parts” and automatically vary the information contained in the header or footer of each part. There is no intrinsic way to do this in Excel; the best approach is a macro to do the following:
1. Set the print area based on a named range.
2. Set the header or footer based on another named range.
3. Print the print area.
4. Repeat steps 1 through 3 for each desired print area.
Notice that these steps require the use of named ranges.
This post is excerpted with permission from Excel.Tips.Net