ExcelBanter - Tracking cursor location

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Tracking cursor location (https://www.excelbanter.com/excel-worksheet-functions/186286-tracking-cursor-location.html)

JonStein

Tracking cursor location

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

Mike

Tracking cursor location

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

"JonStein" wrote:

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

All times are GMT +1. The time now is 02:32 AM.