Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

automatically selecting print area

Posted by Mike Beckage on January 24, 2002 12:48 PM

I have a workbook that has two sheets
On sheet one I enter(paste)data
Sheet two contains formulas to manipulate the data
since the data set varies in size the formula area in sheet two is larger that the data

If you print sheet two it will also print the cell that contain formulas with no results (appear to be blank when you view them). I tried doing a copy paste special values only with the same result.

Is their any way to automatically eliminate the blank cells from the print area.

Re: automatically selecting print area

Posted by Chris D on January 24, 2002 1:50 PM

Wouldn't they need to be totally blank columns or totally blank rows for it to still retain its integrity ?

how about just hiding them ?

right click on the column or row header and "hide"

any luck ?
Chris

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.