Hi.
How to do the following:
1) Return the cell reference of the cell
eg:
Type this formula in cell A1:
=return_cell_reference_of_that_cell()
{The above is a fictitious formula only}

The answer will be A1.
Preferably, it is great for me to decide on how the reference is displayed, eg:
- absolute (ie $A$1) or
- column-absolute (ie $A1) or
- row-absolute (ie A$1)
- relative (ie A1)

2) Return cell reference(s) of the target
eg:
Type this formula in cell B1:
=return_cell_reference(target_cell)
{The above is a fictitious formula only}

eg:
=return_cell_reference(A3)
Answer: A3

=return_cell_reference(A1:A10)
answer: A1:A10

=return_cell_reference(A1,A3,A5)
answer: A1,A3,A5

Again preferably, it is great for me to decide on how the reference is
displayed.
Thanks for your help

--
Additional information:
- I'm using Office XP
- I'm using Windows XP