listindex and blank rows
I am working with a spreadsheet whose columns populate a combo box.
There are blank columns between each used column in the spreadsheet.
I am trying to get a count (including the blank columns) of all
columns for use in my code, by using listindex from the combo box.
Also, I would like for the blank columns to be omitted when populating
the combobox. Would this only be possible with two comboboxes (one
visible and one hidden [to generate the actual count])?
Thanks
Louis
|