| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
defined name with formula as source in VBA
That is it, thanks, Bob!
Stefi Bob Phillips ezt *rta: Activesheet.Evaluate("mydefname") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Stefi" wrote in message ... Hi All, I have a defined name with a formula as its source, and it works in worksheet functions. How can I retrieve its value in VBA? For names with a normal range as source this line works: ThisWorkbook.Names("mydefname").RefersToRange.Item (1, 1).Value but I can't figure out a similar way for formula sources. Thanks, Stefi |
| 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) | |||
| ComboxBox with Dynamically Defined Source, and LinkedCell error | Excel Discussion (Misc queries) | |||
| Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
| How change link source in long formula when source moved | Excel Programming | |||
| Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Hybrid Mode
