Re: Detect if a Defined Name Exists

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

adjust "sth" name to suit yr needs

Sub cus2()
Dim nom As Name

For Each nom In ActiveWorkbook.Names
If nom.Name = "sth" Then
MsgBox "Name 'sth' exists in this workbook"
End If
Next nom

End Sub

On 14 Sty, 14:23, Rob <R...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi.  I was wondering if there was a way for a macro to detect if there was a
field name already in use for a workbook?

I already tried...
If Exist Workbooks("Export.xls").Names("DATA1") Then

As well as...
If Workbooks("Export.xls").Names("DATA1") = True Then

Thanks very much,
Rob

.

Relevant Pages