Thread: Code Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default 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