Function that returns the page number a cell falls on

[Don-in-Kent-UK]

Is there a function I can use in Excel 2002 that returns the page number on
which a particular cell (or line) occupies? I have entries on each page
identified A, B, C etc, and I want to append a suffix to the letter to
indicate which page it is on (A1, B1... A2 etc).

 

[Peo Sjoblom]

There are no built in functions that can do this, you need to write your own
or find some code written by someone else. I would suggest a google search in
the excel newsgroups with the same subject

http://groups.google.com/advanced_search?hl=en


Regards,

Peo Sjoblom