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