I have a sheet with this..
If Selection.Count = 1 Then
If Not Intersect(Target, Sheets("B's").Range("a3:a200")) Is Nothing Then Sheets("SEARCH").Range("B1") = ActiveCell
End If....
which runs
Application.Run "Button22_Click"
another macro. This works fine.
I tried to Record a macro that uses a click on the Range("a3:a200") but it does not record the click.
If Selection.Count = 1 Then
If Not Intersect(Target, Sheets("B's").Range("a3:a200")) Is Nothing Then Sheets("SEARCH").Range("B1") = ActiveCell
End If....
which runs
Application.Run "Button22_Click"
another macro. This works fine.
I tried to Record a macro that uses a click on the Range("a3:a200") but it does not record the click.