Thread: Can I change the reference to a named range via VBA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bassman62 Bassman62 is offline
external usenet poster
  
Posts: 117
Default Can I change the reference to a named range via VBA?
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.


Reply With QuoteReply With Quote