Hello,

I would like to populate a combo box using headers till last column.


1.jpg

So it will populate A, B, C till last used or empty column.

This is what I have so far:

Dim Cell As Range
For Each Cell In Range(Range("A1"), Range("A1").End(xlToRight))
ComboBox1.AddItem (Cell.Value)
Next Cell
Thank You.