ExcelBanter - Problem when getting the printing zoom ration in Excel

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

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

- - Problem when getting the printing zoom ration in Excel (https://www.excelbanter.com/excel-programming/277929-problem-when-getting-printing-zoom-ration-excel.html)

Stephen[_4_]

Problem when getting the printing zoom ration in Excel

Is it possible to programmatically get the actual zoom
ratio (printing) of a sheet after setting the value of
PageSetup.FitToPagesWide or PageSetup.FitToPageTall? I
cannot get the value from PageSetup.zoom since its value
is set to false.

Thanks in advance for any help.

Stephen

All times are GMT +1. The time now is 11:29 PM.