I have the following code, which validates the lenght of the J11 cell:

If Target.Address = "$J$11" Then

Application.EnableEvents = False

With Target

If Len(Range("J11").Value) > 10 Then

MsgBox ("Warning: String is too large.")

End If

End With

Application.EnableEvents = True

End If



What I want to do is to expand this validation to all the cells in
the J column. How can I do this?