Number of pages in the workbook

**HarryX** · 03-11-2010, 04:36 PM

I have a workbook with 3 sheets. Each of these sheets can contain up to 5 pages. The formatting is different on each sheet.
My customer wants to see "Page x of y" written in a certain cell (not in the header - that would be too easy

) and y = number of pages in the workbook!
I found some scripts that can determine the number of pages in a sheet but none that can determine the number of pages in the whole workbook.
Anybody got any hint how to solve this problem?

Thanks, Harry

**6StringJazzer** · 03-11-2010, 04:46 PM

Originally Posted by HarryX

I found some scripts that can determine the number of pages in a sheet but none that can determine the number of pages in the whole workbook.

I could do this from scratch but it will be easier to start with what you already have. If you post the code that determines pages in a sheet I'll show you how to iterate through all the sheets and add up pages in the whole workbook.

**HarryX** · 03-11-2010, 05:09 PM

This worked best so far:

Please Login or Register  to view this content.

I found it here

**dominicb** · 03-11-2010, 05:18 PM

Good evening HarryX

Originally Posted by HarryX

I found some scripts that can determine the number of pages in a sheet but none that can determine the number of pages in the whole workbook.

John Walkenbach has a solution to this here on his old pages.

HTH

DominicB

**HarryX** · 03-11-2010, 06:12 PM

Thanks dominicb, looks like a good point to start from!

Number of pages in the workbook

LinkBack

Thread Tools

Rate This Thread

Display

Number of pages in the workbook

Re: Number of pages in the workbook

Re: Number of pages in the workbook

Re: Number of pages in the workbook

Re: Number of pages in the workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions