When a user double-clicks on a cell in one worksheet (on row 10), I want to put the location of that column in F3 on another worksheet.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column > 2 And Target.Row = 10 Then
Dim c As...