View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Determine if Named Range exists in Worksheet

dim rMyrange as range

on error resume next
set rMyrange=Range("MyRangeName")
on error goto 0

if not rMyRange is Nothing then call MyMacro


HTH
--
AP

"jkt" a écrit dans le message de news:
...
Any suggestions on writing code to look for a named range within a
worksheet
and if it exists, call a macro? Otherwise if named range is not found,
continue with currenty code.