Thread: How to modigy the reference in a named range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_90_] joel[_90_] is offline
external usenet poster
  
Posts: 1
Default How to modigy the reference in a named range?

The names ranges are a workbook object and you can't tell which named
range is on which sheet. You can change the name range using the
replace method like this

For Each nm In ThisWorkbook.Names
nm.RefersTo = Replace(nm.RefersTo, "Sheet1", "Sheet2")
Next nm


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147605

Reply With QuoteReply With Quote