I'm sure the answer is here somewhere, but, I'm a new user and I don't have these forums completely figured out, yet.

I'm trying to have "Page 01 of 04" show up automatically in a specific cell, according to the page of the worksheet (as indicated by "01") and the total number of pages in the worksheet (as indicated by "04").

I need to do this in more than one document, so, I need to know how to have excel determine the total number of pages automatically, since some of the worksheets will have more/less pages.

Thank you so very much.