View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ll ll is offline
external usenet poster
 
Posts: 67
Default Multiple Combo Box Indices?

I am working with a combo box populated with a collection from a
spreadsheet which has some blank cells (intentional). I would like for
the combo box to not display the blank rows (which I've managed to get
it to do), and also for another index to count the total number of
rows. I can't use the index for the combo box, as it omits the blank
rows.
Is it possible to have two indexes (one for display and one for true
row counting)? I need to keep the position in the collection with the
row counting.

Many thanks,
Louis