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 |
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) |