Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing question
Excel XP, Win XP
Simple problem, I think. I have a range to print that is wide so I select Landscape. The width is wider than one page and I want the width to be on one page so I select "Fit to:" and specify 1 page wide. All is well so far. Having selected "Fit to:" I now need to select how many pages "tall". Well, the print range is determined by VBA and the number of pages is a variable. I want Excel to print until it runs out of the print range. My question is: What number do I use for the "tall" entry? Thank you for your time. Otto |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing question
Leave it empty -- not 0, not nothing <bg.
And let excel figure out the number pages it needs based on the width. Otto Moehrbach wrote: Excel XP, Win XP Simple problem, I think. I have a range to print that is wide so I select Landscape. The width is wider than one page and I want the width to be on one page so I select "Fit to:" and specify 1 page wide. All is well so far. Having selected "Fit to:" I now need to select how many pages "tall". Well, the print range is determined by VBA and the number of pages is a variable. I want Excel to print until it runs out of the print range. My question is: What number do I use for the "tall" entry? Thank you for your time. Otto -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing question
What I do in similar situations is I do a print preview before forcing things
onto one page and it will show it wants to print for example 32 pages. I then go back into print setup and tell it to print 1 wide by 16 tall (I choose half the number it shows in the previous print preview.) Often when I do that it will show perhaps a few pages less than the amount I have asked for and then I let Excel decide exactly how many to print. "Otto Moehrbach" wrote: Excel XP, Win XP Simple problem, I think. I have a range to print that is wide so I select Landscape. The width is wider than one page and I want the width to be on one page so I select "Fit to:" and specify 1 page wide. All is well so far. Having selected "Fit to:" I now need to select how many pages "tall". Well, the print range is determined by VBA and the number of pages is a variable. I want Excel to print until it runs out of the print range. My question is: What number do I use for the "tall" entry? Thank you for your time. Otto |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing question
Thanks Dave. I knew there had to be a way. Otto
"Dave Peterson" wrote in message ... Leave it empty -- not 0, not nothing <bg. And let excel figure out the number pages it needs based on the width. Otto Moehrbach wrote: Excel XP, Win XP Simple problem, I think. I have a range to print that is wide so I select Landscape. The width is wider than one page and I want the width to be on one page so I select "Fit to:" and specify 1 page wide. All is well so far. Having selected "Fit to:" I now need to select how many pages "tall". Well, the print range is determined by VBA and the number of pages is a variable. I want Excel to print until it runs out of the print range. My question is: What number do I use for the "tall" entry? Thank you for your time. Otto -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing question | Excel Discussion (Misc queries) | |||
Printing issue | Excel Discussion (Misc queries) | |||
Simple question - one xls sheet keeps printing 6 copies as default | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |