| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a cell name
I have a cell that is named "payment". On another sheet, there are multiple
cells that reference "payment". Is there a way to rename "payment" and change every occurence of it in the workbook? Thanks, Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Renaming a cell name
to change what cell it refers to
worksheets("Sheet2").Range("B9").Name = "payment" to change the name use Edit=Replace -- Regards, Tom Ogilvy "Gary Paris" wrote in message ... I have a cell that is named "payment". On another sheet, there are multiple cells that reference "payment". Is there a way to rename "payment" and change every occurence of it in the workbook? Thanks, Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Renaming tabs from particular cell contents | Excel Worksheet Functions | |||
| vb code for renaming a work sheet with a cell reference | Excel Discussion (Misc queries) | |||
| Maintain cell links when renaming directory containing multiple f | Excel Worksheet Functions | |||
| Opening a template form & renaming it from a cell input automatica | Excel Discussion (Misc queries) | |||
| renaming | Excel Programming | |||
![Gary Paris[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
