Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name range visability
I am programatically creating a workbook. I copy some worksheets over
and need to give a name to a range of cells so another sheet can reference them. I used this code: Names.Add Name:=RangeName, RefersTo:=ReferString, Visible:=True The name appears just find in the sheet named, but the other sheets don't seem to know about the named range. The cells show the #REF! error and the name box is empty. I tried "Thisworkbook.Names", but got the same result. How can I make the names visable to the other worksheets? TIA. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name range visability
wrote: I am programatically creating a workbook. I copy some worksheets over and need to give a name to a range of cells so another sheet can reference them. I used this code: Names.Add Name:=RangeName, RefersTo:=ReferString, Visible:=True The name appears just find in the sheet named, but the other sheets don't seem to know about the named range. The cells show the #REF! error and the name box is empty. I tried "Thisworkbook.Names", but got the same result. How can I make the names visable to the other worksheets? TIA. Also, how do I make it so that the copied sheets refer to the new workbook. That is, I have OldWB.Sheet1 and OldWB.Sheet2. I copy both to NewWB. I want the cell in NewWB.Sheet2 to refer to NewWBSheet1, but it refers to OldWB.Sheet1. (Sorry if this is obivous stuff, but I am not an Excel or vba programmer.) Again, TIA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Picture Link Visability | Excel Discussion (Misc queries) | |||
Excel, highlight cells in which you are typing, for visability. | Excel Discussion (Misc queries) | |||
Trying to toggle visability of button | Excel Programming | |||
Trying to toggle visability of button | Excel Programming |