Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:A10")) Is Nothing Or Target.Count > 1 Then Exit Sub
Target = UCase(Target)
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:A10")) Is Nothing Or Target.Count > 1 Then Exit Sub
[COLOR="Red"]Application.EnableEvents = False[/COLOR]
Target = UCase(Target)
Application.EnableEvents = True
End Sub