Hi.
I'm having some trouble with target cells in event procedure, when i select any range of more than two cells (for cell formatting purposes) the debugger goes on but not sure why?
Here is my code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 28 And Target.Row > 31 And Target.Row < 531 And Target.Value = "UnSelected" Then
        Target.Value = "Selected"
        With Range(Target.Offset(0, -21).Address & ":" & Target.Offset(0, 4).Address)
            .Interior.Color = RGB(204, 255, 204)
        End With
    ElseIf Target.Column = 28 And Target.Row > 31 And Target.Value = "Selected" Then
        Target.Value = "UnSelected"
        With Range(Target.Offset(0, -21).Address & ":" & Target.Offset(0, 4).Address)
            .Interior.ColorIndex = xlNone
        End With
    End If
End Sub