Combobox array

[Lawlera]

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?

 

[lawlera]

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

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