Hi All,

This is just driving me CRAZY!!!

I have a worksheet which I have 20 forms created on that are
automatically filled out via another data entry worksheet. I have
edited them so that they have page breaks. So basically if anyone hits
the print button, all 20 pages print out...ughhhh

What I want to do is ONLY print the pages that have data entered into
them. I have found several posts about this but when I try them I get
error messages by the dozen....

Please can you help me, as I am about to create a new worksheet that
may have up to 400 pages on them and I only want to print the ones with
data entered in THOSE......

The work sheet is called Summary
The cells that ALWAYS contain the data I need are in column G

Thank you in advance
Sandi


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=514285