Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range Cells vs. Absolute Cell Addresses
I have a workbook with many cells with names. Throughout
the workbook the references to these cells are made via the "name". I want to covert all of these references to the physical cell address vs. the name. Are there any clever ways to do this other than one by one? I have a worksheet that contains all the named cells in the workbook and their physical address. I tried writing a macro that did a find and replace. The find worked but the replace did not. It does work manually.. but there are too many to convert manually. Also, are there any utilities that will provide a list of all cells dependent upon a given cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste to next empty cell in named range of cells | Excel Discussion (Misc queries) | |||
RANGE addresses. Getting from other cells. | Excel Worksheet Functions | |||
COUNTIF absolute value of cells in a range are 0 | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
How do I get absolute values for a range of cells? | Excel Discussion (Misc queries) |