software

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

groups.google.com/advanced_search?hl=enRegards,

Peo Sjoblom
quot;Don-in-Kent-UKquot; wrote:

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