Detect if a Defined Name Exists
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 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
|