I didn't check the formula you used; if it says 3 and it should be 5, seems to me there's something wrong with the calculation. All I was really trying to do is show you how to put that value in a cell rather than displaying it in a MsgBox.
But now I'm interested. I can see where counting the vertical and horizontal page breaks and multiplying them might give you more pages than the correct count; it isn't clear to me how it could be fewer. I don't fool with page breaks, myself, and have never looked at those properties. If I think of something in the next few days I'll probably come back and say more. But don't count on it; I think it's gotta be something wrong with the code you found and used.
I'm assuming, by the way, that when you used the MsgBox method, that too gave you the wrong count. My calculation is the same as yours, just phrased differently.
|