View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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