return of selected cell references?

[Andy]

Can any one tell me if there is a function to return the
row and column references of the selected cell (ie where
the cursor is located)to be used in a formulae

I have searched the help without result

Thanks

 

[Bob Phillips]

Andy,

=CELL("address")

will give it, but this does not update when you move, you have to force
calculation (F9). A value change on the sheet will force a re-calculation
though.

 

[Andy]

Thanks Bob

-----Original Message-----
Andy,

=CELL("address")

will give it, but this does not update when you move, you have to force
calculation (F9). A value change on the sheet will force a re-calculation
though.



--

HTH

Bob Phillips




.