| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename all named ranges?
Excel 2000
I have a workbook with 100+ named ranges. I would like to rename them all. Starting all names with "R1" and the old name. I would also like all the formulas in the workbook that refers to the names be changed to the new names. (perhaps this happened automatically?) Thanks Johan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rename unknown named files | Excel Programming | |||
| union of named ranges based only on the names of those ranges | Excel Programming | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| named ranges - changing ranges with month selected | Excel Programming | |||
![Johan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
