Ok, would someone be so kind as to help me here. I am losing my head.

I have a listbox with 9 columns, I want to use the column header feature, so I set the following code:


lstStore.ColumnCount = 9
lstStore.ColumnWidths = "100;20;20;20;20;20;20;20;20"
lstStore.RowSource = "A7:Y24"

My results are as follows where as Colx is for viewing purposes with this post and null is the absence of information:

Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9
A7 null null null null null null B7 null
A8 null null null null null null B8 null
A9 null null null null null null B9 null
A10 null null null null null null B10 null
A11 null null null null null null B11 null
....and so on and so on (kinda hoping this will line up for the viewers)

It doesn't put the Bx in Col2 then put Cx in Col3 then Dx in Col4 and so on...

What am I not doing? I get the headers for the columns to show up, I just am not getting the values for the complete range to populate in the list.


Thurman