Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a named range?
Could someone please help? I'm having trouble creating a named range,
and adding that range to a ComboBox. The range that I want to add is horizontal, cells A1:E1, calling it "Test". When I add "Test" to ComboBox by doing ComboBox1.ListFillRange = "Test", it only shows A1 in the dropdown. But when I change the named range to VERTICAL, cells A1:A5, everything works out perfectly. Can you not create horizontal named ranges? Are my ComboBox properties not set right?.... Please help. DK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel |