AncientTiger
Programmer
Posted this in the Office/Excel forum, but no one seems to know the answer... figured I'd ask PROGRAMMERS 
I've got a 2-dimensional array with data gathered from a database. I can plug this info into a multi-column listbox with the object.List() = data property setting, but for the life of me, I can't figure how to set the column headings in the listbox. (and yes, I know that I can set the .filldatarange property to a range on a sheet, and column headings above the data range will be used.... but I want this all done in the script, and not on the sheet)...
Any ideas? Anyone???
Thx!
AT
I've got a 2-dimensional array with data gathered from a database. I can plug this info into a multi-column listbox with the object.List() = data property setting, but for the life of me, I can't figure how to set the column headings in the listbox. (and yes, I know that I can set the .filldatarange property to a range on a sheet, and column headings above the data range will be used.... but I want this all done in the script, and not on the sheet)...
Any ideas? Anyone???
Thx!
AT