is there a function to see if a name object exists?


(thanks in advance)

Try a function like


Function NameExists(WhatName As String) As Boolean
Dim S As String
On Error Resume Next
S = ThisWorkbook.Names(WhatName).Name
NameExists = (Err.Number = 0)
End Function

You call this with code like

If NameExists(WhatName:="MyRangeName") = True Then
' whatever
Else
' something
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"mark kubicki" wrote in message
...
is there a function to see if a name object exists?


(thanks in advance)