Combobox array

[Guest]

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?

 

[Guest]

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

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