Tracking cursor location

J

JonStein

I am looking for a formula that will give me the address of the cursor at any
given time. (With out using a macro)
 
M

Mike

Paste this function in a standerd module
Function CPosition() As String
'Put this =CPosition() in any cell
Application.Volatile
CPosition = "Cursor is in " & _
ActiveCell.Address(False, False)
End Function
 
Top