Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Code Question | Excel Discussion (Misc queries) | |||
VBA code question | Excel Discussion (Misc queries) | |||
Code Question | Excel Programming | |||
Code Question | Excel Programming | |||
VBA Code Question | Excel Programming |