blazingfury
Programmer
Within an Excel macro (which allows users to print multiple versions of the active spreadsheet), I'm needing to validate that the total page count to be printed (per separate print version) hasn't been altered due to a user adjusting a column width, thereby doubling the printed page count. The information I'm wanting to capture would be what is displayed in the bottom left corner within the Print Preview (example-> "Preview: Page 1 of 8"; I'm needing to capture 8). Page breaks are not manually set within the worksheets, so I cannot base the count on VPageBreaks. Alternately, I could base my logic on knowing if all columns, in current format, will print on a single page, regardless of number of rows. Any suggestions?