I have the following code:
What I want to do is determine what this will cause zoom factor to be and, if it is lower than 60%, assign ActiveSheet.PageSetup.Zoom = 60.With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 100 End With
Unfortunately I can't figure out how to pull the zoom value without assigning it manually. Any help?
Bookmarks