cell address rather than range name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Vlookup using a reference to a named range?(Excel 2000) 4
File names within formulae 3
V/HLookup 3
Excel VBA 1
Excel Named Ranges and Conditional Format 3
Excel {2007} Named Ranges: Renaming, Deleting etc... 4

Back
Top