Hey Guys,

I want to populate a combobox using the column headers (from row 1) on sheet1, i want the range to be dynamic, i've tried simply using a dynamic range which expands across rather than down with no luck.

I think i need to transpose a dynamic range or something similar. Can i do this from entirely within vba, so i dont have to define a range within excel (less to go wrong?)

Thanks in advance,

Jack