Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to a named range
Hi there, is it possible within a formulae to refer to a named range, not by stating the named range, but by refering to a cell, where the contents of a cell is a named range? For eg, if cells a1 to a5 contain numbers and I name that reference Col_A, then if I want the total I can just type = sum(Col_A). Now I want to do exactly the same thing, but instead of the name Col_A in the formulae, I want to use a reference. Thus in cell B1 I have the words Col_A. The formulae =sum(b1) obviously doesnt work. Something like = sum(name(b1)) ? Regards Darin *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to specific cell in named range in Excel formula | Excel Worksheet Functions | |||
How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
Referring to named ranges in a macro | Excel Programming | |||
Referring to named ranges | Excel Programming | |||
referring to a named range on another worksheet | Excel Programming |