Determine if Named Range exists in Worksheet

[jkt]

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.

[Ardus Petus]

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" <jkt@discussions.microsoft.com> a écrit dans le message de news:
89F9FF2E-9A63-4A83-9D2C-A7B0DD4FD9A5@microsoft.com...
> 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.