Why not use fit to print and fit it to one page.

--
Regards,
Tom Ogilvy

"playdohstu " wrote in message
...
I have a layout on a spreadsheet which pulls data from other sources
depending on the user's input, and then needs to be printed.
Most of the time this data will fit on to one print page, however
occasionally the data will overrun to a second page.
The question is, how do I get the second page to print only when there
is data in a specific cell?

Thanks
playdohstu
(Windows 2000, Excel 2000)


---
Message posted from http://www.ExcelForum.com/