For i = LBound(ArrayTextBoxMateriel) To UBound(ArrayTextBoxMateriel)
If ArrayTextBoxMateriel(i) = "" Then
Exit For
Else
....
End If
Next i


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SpookiePower" wrote in message
. dk...
I have this array ArrayTextBoxMateriel(49,3) and I use this code to run
through the array -

Do Until ArrayTextBoxMateriel(X, 3) = ""
....
Loop

But I just found out that it will also search place nr 50 to see if it is
empty, if the
array is full but then it returns - Script out of range -.

I was thinking if it is possible to run through the array til the end,
something
like this

Do Until ArrayTextBoxMateriel(X, 3) = "" or until end of array ??




--
Mit fotoalbum
www.photo.activewebsite.dk