return of selected cell references?

  • Thread starter Thread starter Andy
  • Start date Start date
A

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




.
Click to expand...
 
Back
Top