| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Named Ranges
Can I access a named range defined on sheet1 from sheet2?
I have a loop that iterates though Application.Names and I can see the named range I am interested in. However, I cannot access it via Range(Application.Names("foo")). I get an exception when I do. Is this expected behavior? Any way around this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing Named Ranges
set rng = Workbooks(2).Names("foo").RefersToRange
would be one way. Regards, Tom Ogilvy "Michael Monteiro" wrote in message ... Can I access a named range defined on sheet1 from sheet2? I have a loop that iterates though Application.Names and I can see the named range I am interested in. However, I cannot access it via Range(Application.Names("foo")). I get an exception when I do. Is this expected behavior? Any way around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| named ranges | Excel Worksheet Functions | |||
| Named Ranges | Excel Worksheet Functions | |||
| Named Ranges - accessing a cell | Excel Discussion (Misc queries) | |||
| Accessing named ranges in Excel from VBA | Excel Discussion (Misc queries) | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Linear Mode
