O
Otto Moehrbach
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
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