"GS" wrote:

Do you mean I should clear the the "Fit To" pages wide?
How do I specify pages tall? Also, are these options that you're
talking about available in the Page Setup dialog box?

Yes, these are in page setup. (Sorry for assuming you knew this!)


It's all good. I'm still learning all the minute details of MS Office and
VBA programming.


After posting I thought it might be better to specify 1 pages wide so you
don't get rightmost columns printig on another page.


Okay, I will play with that too. I was basically trying all different
combinations of settings on the Page Layout bar and I was struggling
to print each page at 100% scale on a single sheet. I will see how your
suggestions work today. Thanks again.