VBA check if a name exists

[kenreavy]

Hi

I want to open a file and then pick up a value from a named range but sometimes the range name might not exist. Is there any way to check if the name exists?

 

[DominicB]

Good morning kenreavy

This little routine will return a msgbox if the named range exists and will do nothing if it doesn't. Any good?

Sub Test()
On Error GoTo Last
If Len(ThisWorkbook.Names("MyRange").Name) <> 0 Then MsgBox "Range Exists"
Last:
End Sub

HTH

DominicB