If you mean the cell in which the double click occurred, then one way:
Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Excel.Range, Cancel As Boolean)
With Target
MsgBox "Address: " & .Address & vbNewLine & _
"Row: " & .Row & vbNewLine & _
"Column: " & .Column
End With
End Sub
Put the code in the Worksheet code module.
In article ,
k483 wrote:
What's the VB syntax for determining the current row and current col
prior to a DoubleClick?