View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Schitt Jack Schitt is offline
external usenet poster
 
Posts: 63
Default 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