Test for existence of Name
Hi
try something like the following
dim rng as range
on error resume next
set rng = activesheet.Range("your_name")
if err.number <0 then
exit sub
end if
on error goto 0
--
Regards
Frank Kabel
Frankfurt, Germany
"Jack Schitt" schrieb im
Newsbeitrag .. .
Sorry, trivial one:
In a VBA macro I wish to test for the existence of a name local to
the
active sheet, preferably without triggering an error state.
Syntax needs to be
If <expression then exit sub
Where expression is true when the specified name does not exist.
Help? Thanks in advance
--
Return email address is not as DEEP as it appears
|