Can someone please tell me, how to change a range name, using Microsoft 2007 please ?
L LAB Mar 24, 2009 #1 Can someone please tell me, how to change a range name, using Microsoft 2007 please ?
G Gary''s Student Mar 24, 2009 #2 To change a name from alpha to beta: Sub RenameIt() Set r = Range("alpha") Range("alpha").Name.Delete r.Name = "beta" End Sub
To change a name from alpha to beta: Sub RenameIt() Set r = Range("alpha") Range("alpha").Name.Delete r.Name = "beta" End Sub
S Saruman Apr 2, 2009 #3 Go To Formulas Tab Click on Name Manager Click on Range Name you wish to change Click the edit button Change name to what you want Click OK to finish
Go To Formulas Tab Click on Name Manager Click on Range Name you wish to change Click the edit button Change name to what you want Click OK to finish
