View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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