Can't seem to find that property in Excel. Perhaps you were thinking of
some other application.

--
Regards,
Tom Ogilvy

"JLGWhiz" wrote in message
...
See PageSetUp properties in VBA Help. You can set the FitToOnePageWide
property for each sheet.

"Shawn" wrote:

I have a .xls file that has data that spreads across two printed pages
(or
that I want to spread across two printed pages). If certain critrea are
met,
page 1 prints. If other criteria are met, page 1 and page 2 are printed.
I
need a code that will continue to do the above but fit page 1 on one
printed
page and if both pages are to be printed, then fit page 1 and page 2 on 2
printed pages. Right now, the first page may run over one or two lines
onto
a second printed page. I hope this makes sence.


--
Thanks
Shawn