Helo Folk's

If I have set my pages breaks in an excel worksheet that shows for example
10 pages, can excel ignore page breaks that have no information on them.

For example, all 10 pages hold question to which users insert their
responses. If say pages 5 and 6 have been left blank, can I (when printing)
ignore these two pages so that only pages 1-4 and 7-10 print out. I must
have the page breaks including pages 5 and 6 in case they are used but I
don't want to print them if they are unanswered.

To add to this problempages 5 and 6 if not required would be hidden (by way
of a simple macro) but when I print out the worksheet, a blank page for each
of the hidden page 5 and 6 still come through.

So in short I want excel to ignore any hidden pages form the page breaks.

This question has been post before but worded completely differently so I'm
hoping I'm not confusing anyone here.

Regards,

Pat Convey.