Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 And Target.Row > 2 And Target.Count = 1 Then
Sheet1.[f1] = Cells(Target.Row, 4).Value
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 And Target.Row > 2 And Target.Count = 1 Then
Sheet1.[f1] = Cells(Target.Row, 4).Value
End If
End Sub