Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print to fit one page
Whatever code you are using couldn't you just add something like:
If ***Your Criteria Prints Just Page One*** Then With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 1 End With Else With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 2 End With End If Hopefully this should work. -Brian 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
Use also Zoom
With sh.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = False .Orientation = xlLandscape End With -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Brian B." wrote in message oups.com... Whatever code you are using couldn't you just add something like: If ***Your Criteria Prints Just Page One*** Then With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 1 End With Else With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 2 End With End If Hopefully this should work. -Brian 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
Try this tester for the selection
I will preview the printout Delete preview:=True when it is working correct Sub test() With ActiveSheet.PageSetup .PrintArea = Selection.Address .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 .Orientation = xlLandscape End With ActiveSheet.PrintOut preview:=True End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Shawn" wrote in message ... I tried this but it didn't work: With Selection .FitToPagesWide = 1 .PrintOut copies:=1, collate:=True End With -- Thanks Shawn "Ron de Bruin" wrote: Use also Zoom With sh.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = False .Orientation = xlLandscape End With -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Brian B." wrote in message oups.com... Whatever code you are using couldn't you just add something like: If ***Your Criteria Prints Just Page One*** Then With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 1 End With Else With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 2 End With End If Hopefully this should work. -Brian 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) |