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.
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.
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" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks