I have a report that is 12 pages in its entirety. I am using the Page
Break view and setting the begining of each page using the page break
feature. There are times when this report has no data on pages 4-5 and
when I print I only want the pages that contain data (Page 1-10 of 10
instead of page 1-12 of 12).

If I hide the rows that comprise pages 4-5 and then print the report,
my page count is still 12 and pages 4-5 are completely blank.

If I remove all the page breaks and hide the cells and then apply page
breaks where appropriate, this effectively adjusts the number of pages
printed.

My problem is that this report is automatically generated from
information that is input on seven other worksheets and is part of a
template. This template is used to launch a new data-entry series every
week.

I do not want to have to format this report every week. Is there a way
to hide pages that use the page break function and not have those pages
print with the rest of the report?

-Slave


--
Slave2Six
------------------------------------------------------------------------
Slave2Six's Profile: http://www.excelforum.com/member.php...o&userid=36904
View this thread: http://www.excelforum.com/showthread...hreadid=567244