Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defined Name
How can read my Global Const statements, use the name value and create a
defined name as in Insert|Name|Define Global Const XXX = 21 In the name box I want "XXX", in the Refers to box I want =21. All this VBA code. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defined Name
"Sheldon" wrote in message
... How can read my Global Const statements, use the name value and create a defined name as in Insert|Name|Define Global Const XXX = 21 In the name box I want "XXX", in the Refers to box I want =21. Hi Sheldon, ThisWorkbook.Names.Add "XXX", "=21" -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Application defined or Object defined error | Excel Programming | |||
Word.Document - user defined type not defined | Excel Programming | |||
Application-defined or object-defined error | Excel Programming |