Jim Rech and Nick Osdale-Popa posted this that might help:

http://groups.google.com/groups?thre...%40tkmsftngp05

MacroMan wrote:

Please Help!

I am using VBA in Excel XP with Windows 2000.

When you manually set the "Fit To" print settings to one
page wide by one page long the "Zoom" percent value
changes even though the "Fit To" option is being used.

Because the Zoom option is not on, its value is set
to "False" if you try to retrieve that percentage
using "Activesheet.PageSetup.Zoom". I need to obtain that
percentage when the "Fit To" option is on. How can I get
it?

Your example code is most appreciated. Thanks in advance.

--

Dave Peterson