Function for cursor location
There is no such function but there is now. You must paste it to a standard
module. However, it will only update when the worksheet is calculated:
Function CPos() As String
Application.Volatile
CPos = "Cursor is in " & ActiveCell.Address(False, False)
End Function
If you need it to update when the cell selection is changed (cursor position
changes) then you need to also paste this to the worksheet's module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Calculate
End Sub
To get it to work, enter this into the desired cell:
=CPos()
Regards,
Greg
|