UBound(ary)-LBound(Ary)+1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Keri" wrote in message
...
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