| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restoring formulas after deleting range names
Hello
I am using Excel 2003. I would like to have "normal" formulas where I am currently using range names. How can I restore the cell references i.e. not just get the NAME? error when the range name is deleted. -- Thanks very much. KDJ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Restoring formulas after deleting range names
Insert Name Define under Names in workbook: create a name range OK
"KDJ" wrote: Hello I am using Excel 2003. I would like to have "normal" formulas where I am currently using range names. How can I restore the cell references i.e. not just get the NAME? error when the range name is deleted. -- Thanks very much. KDJ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Restoring formulas after deleting range names
I think I worded my question wrong.
I would like to restore the normal formulas using cell references. I do not want to use the range names anymore. I cannot simply delete the name because then I get an error. How do I get back to the original cell references? -- Thanks very much. KDJ "Teethless mama" wrote: Insert Name Define under Names in workbook: create a name range OK "KDJ" wrote: Hello I am using Excel 2003. I would like to have "normal" formulas where I am currently using range names. How can I restore the cell references i.e. not just get the NAME? error when the range name is deleted. -- Thanks very much. KDJ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Restoring formulas after deleting range names
You have to delete a name range, then in your formula substitute a name range
to what ever your range is "KDJ" wrote: Hello I am using Excel 2003. I would like to have "normal" formulas where I am currently using range names. How can I restore the cell references i.e. not just get the NAME? error when the range name is deleted. -- Thanks very much. KDJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying range names to existing formulas in separate worksheets | Excel Discussion (Misc queries) | |||
| Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
| Macro to copy range of formulas to equal data lines | Excel Worksheet Functions | |||
| Replace range names with cell references? | Excel Worksheet Functions | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
Hybrid Mode
