Hello everyone,

I decided to re-post my question since it was ignored the first time.
Maybe I'll get lucky on second attempt. I just wonder, is this question
so not interesting to the Forum members?

So, here I go again.
I hope that somebody has had experience with what I have to accomplish.
I'd really appreciate any ideas and tips on that. Code samples - dream
come true.
So here goes.
After applying specific page settings to spreadsheet - could be
multiple spreadsheets in a workbook - before printing, it gets broken
down into certain amount of pages - or print areas - and some of these
could contain nothing but grid lines and columns' headers. So they
essentially are blank. And sometimes there could be as many as 100s of
these pages depending on the number and width of columns in the
spreadsheet, and we have to either manually reformat Excel files to get
rid of blank pages, or just pull out, again manually, all these pages
from paper printout, which is very annoying and time-consuming.
Is there a way to programmatically find these blank pages and exclude
them from printing? We're talking about processing of 100s of Excel
files at a time - hense, batch printing.

Thank you in advance.


--
sgluzberg
------------------------------------------------------------------------
sgluzberg's Profile: http://www.excelforum.com/member.php...o&userid=23528
View this thread: http://www.excelforum.com/showthread...hreadid=375598