Quote:
Originally Posted by BobBridges
Heck, if he wanted to increase Zoom until it was up to 40, all he'd have to do is say
Code:
If .Zoom < 40 Then .Zoom = 40
(I speak under correction, because I've never done anything with Zoom in VBA.) I think he's saying that he wants to keep on adding pages until the zoom is at least 40%.
|
That's not how I read it. As posted, if the zoom is less than 40%, increase by 1%. Recheck. If the zoom is still less than 40%, increase by 1% and exit. Thus, if the zoom started out at 36%, it would be increased to 38% only. Similarly, if it starts at 39.5% it would be increased to 40.5%.