If the pages are blank that aren't wanted there is probably something
else that is wrong.
Cells with spaces, empty string, or cells with formulas are never blank.
Check your last cell Ctrl+End it should point you to the intersection of the
last used row and the last used column. If it doesn't then you have a
last cell problem. Watch out for hidden calculation areas -- a bad idea
but some people do that.
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell
I'd think use of Print Area to be a resolution of last resort, the need for
it usually indicates a problem.
