| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to modigy the reference in a named range?
Thank you Joel.
.... Rick "joel" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference named range | Excel Programming | |||
| Combox Box - Need to Reference Named Range | Excel Programming | |||
| Can I change the reference to a named range via VBA? | Excel Programming | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Reference a named range | Excel Programming | |||
Threaded Mode
