| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Named Range in Worksheet_Change event
I have the following IF statement in my worksheet_Change event
If Not Intersect(Target, Range("A1:A20")) Is Nothing Then I'd like to replace "A1:A20" with a named range. What do I need to change to get this to work. Let's say the named range is "BARB" for this example. Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet_Change Event with Range Protection | Excel Discussion (Misc queries) | |||
| Lock or Unlock Range of Cells on Worksheet_Change Event | Excel Worksheet Functions | |||
| Change event triggered by a named range | Excel Programming | |||
| Change Event on a named range | Excel Programming | |||
| Worksheet_Change Event | Excel Programming | |||
Threaded Mode
