View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dksaluki dksaluki is offline
external usenet poster
 
Posts: 48
Default 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