Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, [D4]) Is Nothing Then
Macro1
ElseIf Not Intersect(Target, [D6]) Is Nothing Then
Macro2
ElseIf Not Intersect(Target, [D8]) Is Nothing Then
Macro3
ElseIf Not Intersect(Target, [D10]) Is Nothing Then
Macro4
End If
End Sub