Thanks to Chip and Dave.
This helps my understanding of referencing named ranges in VBA.

"Dave Peterson" wrote in message
...
You can just reassign the Name to a different range:

worksheets("sheet99").range("z9").name = "Home"




Bassman62 wrote:

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.

--

Dave Peterson