Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
How can I add a duplicate named range, local to a worksheet? When I insert/name/define, the "master one" (vs. local) disappears from another sheet.
Sheet1 has range Database. I call it "master" - it's the one that F5 sends you to.
Sheet2 has a local range Database.
Sheet3 has a local range Database.
I want to put a local range Database on Sheet4. But insert/name there wipes out the defined name on Sheet1.
Somehow I managed the trick on sheet2 and 3, probably by importing. What's the more direct way to do it?
Hey, #500 as I write this.
Sheet1 has range Database. I call it "master" - it's the one that F5 sends you to.
Sheet2 has a local range Database.
Sheet3 has a local range Database.
I want to put a local range Database on Sheet4. But insert/name there wipes out the defined name on Sheet1.
Somehow I managed the trick on sheet2 and 3, probably by importing. What's the more direct way to do it?
Hey, #500 as I write this.