Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |