It is best to introduce a hard break in the print setup and then use the
print header, but you can determine on what page a cel is located:

http://groups.google.com/group/micro...3252502ce2ac30


--
Gary''s Student
gsnu200709


"Solograndma" wrote:

I have a workbook that has 4 worksheets. 2 of the worksheets have 3 printable
pages. I am trying to create a formula that will keep a number in the first
three pages, but change the numbers if and when data is entered into a
particular cell of one or all of the 3 pages of another worksheet. example:
Page 1 of 3, Page 2 of 3 and Page 3 of 3 are in one worksheet. The other
worksheet has 3 un-numbered pages. If I enter data in a cell of one of these
pages, I want the first worksheet to show Page 1 of 4, Page 2 of 4 and Page 3
of 4.