View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SpookiePower SpookiePower is offline
external usenet poster
 
Posts: 30
Default Until end of array ?

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