Calculating pagenumbers before printing

  • Thread starter Thread starter PO
  • Start date Start date
P

PO

Is there any way to calulate the total pagenumbers before printing a
worksheet?

I want to do the following:

Sub PrintTest
numPages = calulate the number of pages to be printed
activesheet.range("D10").value=numPages
activesheet.printout
End Sub

I don't want to use the &N formatcode in the page header/footer.

Regards,
PO
 

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

Printing in reverse order 2
YYY-MM-DD format is changing when convert data to Flat File 3
insert pagenumber in PageSetup in Excel using VB.net 1
How to count number of pages in a named range 2
Pagenumber problems 4
runtime error #9 subscript out of bounds #4 2
runtime error 9 subscript out of range #3 3
Print Macro - Printing out of order 2

Back
Top