Rename a range .
 

Can someone please tell me, how to change a range name, using Microsoft 2007
please ?

Rename a range .
 

To change a name from alpha to beta:

Sub RenameIt()
Set r = Range("alpha")
Range("alpha").Name.Delete
r.Name = "beta"
End Sub

--
Gary''s Student - gsnu200840


"LAB" wrote:

Can someone please tell me, how to change a range name, using Microsoft 2007
please ?

Rename a range .
 

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

--
Saruman

(There is a time and place for code when Excel can't manage the problem
straight out of the box)
---------------------------------------------------------------------------
All Outgoing Mail Scanned By AVG Free 8
---------------------------------------------------------------------------
"LAB" wrote in message
...
Can someone please tell me, how to change a range name, using Microsoft
2007
please ?