Here is how I do it. Say you want to move the named range from A2 to B3.

Sub dk()
ActiveWorkbook.Names("Home").Delete
ActiveWorkbook.Names.Add "test", RefersTo:="=Sheet1!$B$3"
End Sub

It will also work for a range like Sheet1!$A$2:$C$12


"Bassman62" wrote in message
...
I have a range named "Home" that refers to: =Sheet1!$A$1.
What Macro code would I use to change the reference?
Thanks for any advice.