I am working on a macro that temporarily hides rows and columns for
printing. On one print 'job' i need to increase the scaling (as if
going to file, page setup, scaling, adjust to) and set to change to
what ever i have pre-defined the scale to be. After i print, i need to
set it back to whatever it originally was.

I searched for this on the forum, but didn't find something that was
exactly what i need. Any help for this novice much appreciated!


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=387877