Code Question
What do the following statements mean or do?
1) Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("Order").Activate
If Target.Count 1 Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
I know the above will execute when there is a change on the worksheet, but I
don't know what the part in the () does or means. I have also been unable
to locate in the HELP section anything to do with TARGET.xxxxxxx.
2) Application.EnableEvent = TRUE/FALSE
What does this command affect and why would it be used?
3) If Not Intersect(Target, Range("A13:B90")) Is Nothing Then
If Target.Column = 1 Then
All above programming appear in a macro I use, but I was given the code via
this forum from questions I had.
Thanks,
Les
|