creating dynamic number of rows in a listbox

Hi,

I am writing an application to load the number of members that match a criterion into a ListBox in a Userform. This is a multicolumn array

To start with I have defined the array with the maximum number of members that can be possibly populated into this list box. However, I find that if the actual number of members is less than the maximum number, blank rows are created in the ListBox. My code is as follows:

Please Login or Register  to view this content.

I tried to redim the array using the actual number of records populated which is the value for AryRow

Please Login or Register  to view this content.

This always gives me an error.

Hope some one will be able understand my code and help me with restricting the ListBox entries to the actual records populated

Anand

You'll have to test for a blank cell and NOT add that to the array. Or you could do this.

Please Login or Register  to view this content.

Since you are already iterating the cells, why not just add them to the listbox as you go? Instead of iterating to add them to the array, then adding them to the listbox.