| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
You can rename a name using VBA
ActiveWorkbook.Names("Joe").Name = "freddy" but any existing references in formulae etc to the previous name will NOT be changed and so will be invalid. regds Charles Williams Decision Models "Bob Phillips" wrote in message ... Rick, You can't rename a name, you have to delete it and then create a new name with the same refers to value. -- HTH RP (remove nothere from the email address if mailing direct) "rickv" wrote in message ... How do you Rename Defined Name? -- rickv ------------------------------------------------------------------------ rickv's Profile: http://www.excelforum.com/member.php...o&userid=25942 View this thread: http://www.excelforum.com/showthread...hreadid=393202 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel is substituting unicode for a defined name of a cell | Excel Discussion (Misc queries) | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| user defined function row number | Excel Worksheet Functions | |||
| Defined range problem | Excel Discussion (Misc queries) | |||
| User defined charts- font size too small | Charts and Charting in Excel | |||
Threaded Mode
