Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Range to Worksheet Names Collection
Hi I use the worksheet names collection on a hidden
sheet to store drop down values for comboboxes using the combobox listfillrange property Note I am referring to the Worksheet names collection NOT the workbooks Name collection This works fine but in Excel 2000 I cant find any way to add a new range to the collection without writing a VBA function ! I can add it to the Workbooks name collection using the GUI brought up by InsertNameDefine but I want it specific to that hidden sheet Programmatically I can add it simply enough Dim mywks As Worksheet Dim myname As Name Set mywks = ActiveSheet With mywks mywks.Names.Add Name:="RHOV", RefersTo:="Unit_Def.Map!$BK2:$BK4" End With Trouble is I want end users to be able to do it Does anybody know how this is meant to be done using Excel's own interface ? Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Range to Worksheet Names Collection
What you want to do is called creating a local name. In the Define Name
dialog precede the name with the active sheet's name: Sheet1!MyName -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Range to Worksheet Names Collection
"Jim Rech" wrote in message ... What you want to do is called creating a local name. In the Define Name dialog precede the name with the active sheet's name: Sheet1!MyName -- Jim Rech Excel MVP Thanks Jim I appreciate it. I knew there must be a way but after 3 hours scanning the help files and tearing my hair out I coulldnt find it. Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding range names | Excel Discussion (Misc queries) | |||
Adding Range Names | Excel Worksheet Functions | |||
calculating and adding a range to a collection | Excel Programming | |||
Names Collection | Excel Programming | |||
Adding and deleting Range Names | Excel Programming |