Thread: Can I change the reference to a named range via VBA?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Can I change the reference to a named range via VBA?
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
Reply With QuoteReply With Quote