ExcelBanter - Number of pages

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

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

- - Number of pages (https://www.excelbanter.com/excel-programming/401961-number-pages.html)

fred

Number of pages

Hi,
I would like to know, programatically, how many pages will be printed if I
print a particular worksheet.
In the PageBreak view or PageLayout view it gives the page numbers but how
can I get that information programatically.

Thanks for any help,
Fred

ilia

Number of pages

This function will return the number of pages that will be printed.

ExecuteExcel4Macro("GET.DOCUMENT(50)")

It applies to the ActiveSheet only, as far as I know.

On Nov 29, 6:49 pm, "Fred" <leavemealone@home wrote:
Hi,
I would like to know, programatically, how many pages will be printed if I
print a particular worksheet.
In the PageBreak view or PageLayout view it gives the page numbers but how
can I get that information programatically.

Thanks for any help,
Fred

All times are GMT +1. The time now is 01:57 AM.