Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two-dimensional Named Ranges
Hi,
Can anyone tell me if you can use "2 dimensional" named ranges? So, for example, if you had cells B1:D1 named UK, FR, CH respectively and A2:A4 named Car, Boat, Train, is there a way to reference programatically (and or) manually the value of D4 by using "Train,CH" (or some equivilent). I understand the use of Offset, but was wondering if there is a direct method. Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Named Ranges | Excel Programming |