Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect if a Defined Name Exists
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application-Defined or object defined error 1004 When ran on exel97 but not 2003 | Excel Programming | |||
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
Detect if file exists | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming |