Number of pages

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HPageBreak not working 4
Page setup problems in VBA 1
Problem removing page break 5
Printer orientation with multi pages 4
Programatically set up footer 2
Finding automatic page breaks in new, blank worksheet 1
HPageBreak not working - More info 1
Print entire workbook with each sheet starting at page 1 8

Back
Top