JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
Suppose I want to show the names of various named ranges in a table. In this table, for example, I have assigned the name "Price" to Column C and "Quan" to Column D. I would like to put some expression, like "=RangeName(C:C)", into C6 and D6 that would show those names and would change if I renamed those ranges.
<tbody>
</tbody>
If this does not exist, can I write a UDF that will do the job?
Thanks
R/C | C | D | E | F |
5 | Unit Price | Quantity | Cost | Formula |
6 | (Price) | (Quan) | () | () |
7 | $9.98 | 250 | $2,495.00 | E7: =Price*Quan |
8 | $1.29 | 500 | $645.00 | E8: =Price*Quan |
9 | $5.49 | 130 | $713.70 | E9: =Price*Quan |
<tbody>
</tbody>
If this does not exist, can I write a UDF that will do the job?
Thanks