Print to fit one page
 

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

Print to fit one page
 

If the OP uses the Help file, he will get the correct sytax.

"Tom Ogilvy" wrote:

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

Print to fit one page
 

The Help file doesn't contain an entry for

FitToOnePageWide

Either. "No Results Found". (Nor would I expect it to since it isn't a
property in Excel.)

If the OP uses the Help file, he will get the correct sytax.

No, I don't think the OP would get much help searching on that property.
There is a differnce between syntax for an existing property and finding
non-existent syntax on an imaginary property. Don't despair over your
misdirection however.

Fortunately, Brian and Ron were able to provide good answers to the
question.

--
Regards,
Tom Ogilvy


"JLGWhiz" wrote in message
...
If the OP uses the Help file, he will get the correct sytax.

"Tom Ogilvy" wrote:

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