I am trying to use the ColumnHeads feature in the listbox. The only issue I have is I have always used the .Add Item method.

If all my data is on sheet (Data), how do I name a range thru code to fill the listbox property so I can set the ColumnHeads to true.

Row 1 is a Header Row
A thru E have data
Last row may vary

Thanks for any help or feedback,

Josh