Is there a function in Visual Basic that returns the
number of entries in an array? I am writing a code that
loops through cells in excel, looks for a value -- if
there is a value it assigns that value to the next spot in
an array -- if the cell is blank the loop is broken. I
need to know how many values were found.

Thanks
Keri