We all know that Jamie is a bit of a half ass hack at programming and his method suxlol
Arbiter, redim preserve is slow and so should be used as little as possible. Modify the Irish git's form load code (the second half) for something like this..
Good to have you and ur barnyard animals back JamieVB Code:
lCounter = -1 ReDim tempArr(UBound(myArray)) For i = 0 To UBound(myArray) If myArray(i).exists Then lCounter = lCounter + 1 tempArr(lCounter) = myArray(i) End If Next ReDim Preserve tempArr(lCounter) ReDim myArray(lCounter) myArray = tempArr![]()




lol
Reply With Quote