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).

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



"Don-in-Kent-UK" wrote:

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).