ExcelBanter - read ZOOM after setting FitToPagesWide in pagesetup

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - read ZOOM after setting FitToPagesWide in pagesetup (https://www.excelbanter.com/excel-programming/275862-read-zoom-after-setting-fittopageswide-pagesetup.html)

Richard Daniels

read ZOOM after setting FitToPagesWide in pagesetup

try using

ActiveSheet.PageSetup.Zoom

-----Original Message-----
i need to read the zoom percentage that is generated
after the FitToPagesWide value is set.
.

bruce taylor

read ZOOM after setting FitToPagesWide in pagesetup

unfortunately that gives a result of "false".

can you suggest another point of attack?
thks
-----Original Message-----
try using

ActiveSheet.PageSetup.Zoom

-----Original Message-----
i need to read the zoom percentage that is generated
after the FitToPagesWide value is set.
.

.

All times are GMT +1. The time now is 07:28 AM.