Thank you very much.
This helps a great deal!
Best Regards


"JLGWhiz" wrote in message
...
Sorry about the typo, should have been Home in both places.

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



"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.