Test for existence of Name
 

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

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

Test for existence of Name
 

Thanks Frank

--
Return email address is not as DEEP as it appears
"Frank Kabel" wrote in message
...
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