Listbox Rowsource based on columns

Hi I'm trying to populate a single column listbox with the column headers of a dynamic range (a1 to last column) but i can't seem to convert that range to a list ie..

a1
b1
c1
d1
etc...

any ideas how to do that? i tried rowsource but it doesn't seem to do anything

Please Login or Register  to view this content.

any help would be much appreciated

Thanks,

Chris