I have a worksheet with various named print ranges.

There is a cell on the first line of each named range that has a value that
I need to look up to tell if I need to print that range or not.

Such as, the cell in the first row of each print range in column "I" is
equal to "EXCLUDED" that range doesnt need to be printed. If that cell is
equal to a number it needs to be included in the "Print_Area".

Also I have a header for each page, and a footer for the form. Can this all
be incorporated into one "Print_Area" useing VBA? If so, can anyone help
with the code??

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming