Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell address rather than range name
In formulas, I want to use the cell address for a named range rather than the
range name. Ex: If cell A1 is named "price", I want the formula referencing it to use the cell address (A1), not the range name (price). That is, =A1 rather than =price. Excel defaults the range name, and I haven't found a way to replace it with the cell address (other than typing it in). Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell address rather than range name
range("price").address
"Angi Bemiss" wrote: In formulas, I want to use the cell address for a named range rather than the range name. Ex: If cell A1 is named "price", I want the formula referencing it to use the cell address (A1), not the range name (price). That is, =A1 rather than =price. Excel defaults the range name, and I haven't found a way to replace it with the cell address (other than typing it in). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |