#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Count Pages

Is there a way to count the number of pages being used in a spreadsheet and
then show them in a msgbox?

Thanks,
Heather


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Count Pages

Hi
have a look at
http://tinyurl.com/2hxdu

--
Regards
Frank Kabel
Frankfurt, Germany


Heather Irvin wrote:
Is there a way to count the number of pages being used in a
spreadsheet and then show them in a msgbox?

Thanks,
Heather

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default Count Pages

try
msgbox activeworkbook.sheets.count

--
Don Guillett
SalesAid Software

"Heather Irvin" wrote in message
...
Is there a way to count the number of pages being used in a spreadsheet

and
then show them in a msgbox?

Thanks,
Heather




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 to count number of pages in worksheet msnews Excel Worksheet Functions 9 May 7th 14 12:26 PM
how to count number of pages in worksheet msnews Excel Discussion (Misc queries) 8 April 11th 08 02:39 PM
Count number of pages rm81 Excel Worksheet Functions 3 June 9th 06 05:52 PM
How do I keep blank pages from being included in header count? R00ster Excel Worksheet Functions 3 October 21st 05 02:57 PM
COUNT ACROSS SEVERAL PAGES OZDOC1050 Excel Discussion (Misc queries) 3 September 5th 05 06:28 PM


All times are GMT +1. The time now is 03:23 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"