| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List Box - For Input Range can I use named range in another workbo
Hi folks,
In Book2 I have a named range "Employees". In Book1 I have a list box. In the Format Control option for my list box I select the Input Range area. I have typed numerous variations of the following but I keep getting a 'Reference Is Not Valid' or similar error: 'C:\Program Files\systems\My Program\Data1\[Book2.xls]Sheet1'!Employees |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List Box - For Input Range can I use named range in another workbo
The other book needs to be open
'Book2.xls'!Employees -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dim" wrote in message ... Hi folks, In Book2 I have a named range "Employees". In Book1 I have a list box. In the Format Control option for my list box I select the Input Range area. I have typed numerous variations of the following but I keep getting a 'Reference Is Not Valid' or similar error: 'C:\Program Files\systems\My Program\Data1\[Book2.xls]Sheet1'!Employees |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List Box - For Input Range can I use named range in another wo
Thanks Bob. I've adapted a macro to open the Book2 file before navigating to
the list box. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple instances of a named range, not in the list | Excel Discussion (Misc queries) | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Input Range for a List Box | Excel Worksheet Functions | |||
| input range in drop down list | Excel Discussion (Misc queries) | |||
| How can I use a named range for "pick from drop-down list"? | Excel Discussion (Misc queries) | |||
Linear Mode
