Combobox array
 

I am trying to find some code to quote a named array for the list within a combobox, rather than quoting the range explicitly.

Can anyone help please?

Combobox array
 

ComboBox1.List = Range("a").Value

e.g. assumes "a" is the named array.