Thread: Can I change the reference to a named range via VBA?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Can I change the reference to a named range via VBA?


ActiveWorkbook.Names("Home").Delete

You don't need to delete the name, although it is harmless to do so
and it adds clarity to the logic of the code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 21 Mar 2009 19:33:40 -0400, "JLGWhiz"
wrote:

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.



Reply With QuoteReply With Quote