#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nikki
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I continuously number pages for the entire workbook? Pattie Excel Discussion (Misc queries) 5 June 9th 06 12:23 AM
Count Number of Characters in a cell? AHJuncti Excel Discussion (Misc queries) 2 June 16th 05 07:39 PM
Need number of Saturdays and number of Sundays between 2 dates Class316 Excel Worksheet Functions 1 June 10th 05 02:47 AM
numbering all pages in worksheet Lyn Familant via OfficeKB.com Excel Discussion (Misc queries) 1 February 12th 05 02:26 AM
How to print a worksheet but number the pages by workbook Frank Clayton Excel Discussion (Misc queries) 2 January 10th 05 10:52 PM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"