PageSetup object:
Returns or sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing. Applies only to worksheets. Read/write Variant.
If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.
Window object:
Returns or sets the display size of the window, as a percentage (100 equals normal size, 200 equals double size, and so on). Read/write Variant.
You can also set this property to True to make the window size fit the current selection.
Remarks
PageSetup object:
All scaling retains the aspect ratio of the original document.
Window object:
This function affects only the sheet that's currently active in the window. To use this property on other sheets, you must first activate them.