Detect if a Defined Name Exists
dim myName as Name
Set myName = nothing
on error resume next
set myname = Workbooks("Export.xls").Names("DATA1")
on error goto 0
if myname is nothing then
'doesn't exist
else
'does exist
end if
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
--
Dave Peterson
|