You would need VBA for that. The problem with this is you would need a
calculation to perform prior to the formula being updated. You could use a
UDF like this ...
Public Function ACTIVECELLADDRESS() As String
Application.Volatile True
ACTIVECELLADDRESS = ActiveCell.Address(False, False)
End Function
Then call from a cell lik this ...
=ACTIVECELLADDRESS()
The code would need to go in a standard module (Alt + F11, select your
project | Insert | Module).
HTH
--
Zack Barresse
MikeL said:
Sorry, I should have been more specific...the formula you gave lists the
address of the cursor in the box where the cursor is located....is there a
formula that I could enter, say, in A1 that would show the address of the
cursor regardless of where the cursor is located? Thanks for your help.