Number of pages
 

Hi,

Is there a formula to tell you how many pages there are in a document to
print? I know you can look in print preview, but I want the number of pages
to appear in the document. Numbering each page is not something i want to
do either on this particular document.

Pat

Number of pages
 

Pat,
I came across this yesterday while searching around for an answer to a
question I had myself.
John Walkenbach has a website about quirks in Excel and its associated
VBA. I don't know much about how you would implement this into your
worksheet, but I'm sure after more searching on his page, you'll find
how.
http://www.j-walk.com/ss/excel/tips/tip65.htm

Nikki