Maybe I'm missing something, but you can do this very easily in a footer.
It's somewhat complicated (and not foolproof) to do it using a formula in a
cell.

--

Vasant

"Brandon" wrote in message
...
Did you ever happen to get a full answer to this? I'm having the same
issue.
The reply that allows you to create the insertable "getsheetcount"
function
works for the total pages issue, but what about the "1 of x", "2 of x"
issue?
Is there a macro to create a function in a cell to identify the sheet
you're
on, insert the "of" in between, and then show the total number of sheets?

"carlos sosa" wrote:

excel doesn't have a function to count sheets in a book. i think it is
useful
when a result depends on the number of sheets you have in a book. for
example, i would like to number the pages 1 of 3, 2 of 3 and 3 of 3
automaticaly and it is imposible if excel is no able to count sheets
unless
you use a macro with visual basic.