A lot of the time when I use fit to 1 pages wide but leave the fit to Pages high blank, it will make the font a lot smaller then needed. Is there another way to accomplish this?
A lot of the time when I use fit to 1 pages wide but leave the fit to Pages high blank, it will make the font a lot smaller then needed. Is there another way to accomplish this?
I always type in a high value for Pages High. It will only print pages with data, so the value doesn't matter.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
thanks,
I just tried that and it didn't help.