View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default 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