| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define Names / RefersToRange
hi,
i defined a Name "MyName" like =locACTIVE_Template!$P$49;locACTIVE_Template!$P$86 in VBA i wrote Dim rng As Range Set rng = ActiveWorkbook.Names("MyName").RefersToRange but the code fails and the RefersToRange is nothing. any idea? -- André Achtermeier ---------------------------------------------- www.appliedtechnologies.de ---------------------------------------------- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Questions on Define Names | Excel Discussion (Misc queries) | |||
| Invalid define names | Charts and Charting in Excel | |||
| Define Names in Excel | Excel Discussion (Misc queries) | |||
| how to define range names | New Users to Excel | |||
| alternate UI for Define Names ?? | Excel Discussion (Misc queries) | |||
Threaded Mode
