Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you print single page multiply times with increasing page . | Excel Worksheet Functions | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) |