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 ?