Does Named range exist?

**Cbrehm** · 05-07-2011, 06:35 AM

How do I check to see if a named range exists in VB

range TSF for example?
Thanks

**snb** · 05-07-2011, 07:39 AM

To check the existence of the named range 'snb':

Sub tst()
   msgBox  [isref(snb)]
End Sub

**Cbrehm** · 05-07-2011, 08:11 AM

Originally Posted by snb

To check the existence of the named range 'snb':

Sub tst()
   msgBox  [isref(snb)]
End Sub

Thank you for your help

**royUK** · 05-07-2011, 08:48 AM

Alternative as UDF

The following VBA procedure will return TRUE if the name specified in TheName exists, or will return FALSE otherwise.
[/code]
Function NameExists(TheName As String) As Boolean
On Error Resume Next
NameExists = Len(ThisWorkbook.Names(TheName).Name) <> 0
End Function[/code]