I tried this code, but it doesn't work.
It only works when the range is a single cell, like this:
Thanks!
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = Range("D8", "R58").Address Then Call Macro1
End Sub
It only works when the range is a single cell, like this:
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = Range("D8").Address Then Call Macro1
End Sub
Thanks!