Unanswered: clear array (including nulling UBound/LBound)
i have a procedure level declaration of an array which is used to hold the results of a split().
it is a critical part of my source-file validation that the code makes zero assumptions about the number of elements in the array (this part of the validation is precisely about checking the number of fields in the source data)
the array is reused by a loop for each available source file.
so the question: how to return a previously declared array to the initial virgin state that was generated by
dim myArray() as string
after the first split() has populated it with 32 elements?
i do NOT want to move the array declaration out of the looping procedure.
currently using SS 2008R2