PDA

View Full Version : Solved: Getting Page Count for a Workbook



bbk5
07-11-2007, 01:32 PM
So I'm attempting to get an accurate page count for an entire workbook but I'm having a tough time. Right now I'm trying to count the number of horizontal page breaks per sheet, but this is giving me some inconsistent answers. Also, I'm getting some strange out-of-bounds errors when I try to loop through a page break collection.

Is there an easier way to get the page count? Any help would be greatly appreciated.

mdmackillop
07-11-2007, 01:49 PM
Have you tried this? (http://j-walk.com/ss/excel/tips/tip65.htm)

bbk5
07-12-2007, 08:42 AM
Thanks, that Excel macro did the trick!