array variable is empty?
Hi.
Pretend I have an integer array variable that I'm using for somthing,
arIntArray()
There's a loop that goes through and populates the elements of that array,
which are a subset of the columns in the spreadsheet.
If it turns out that there aren't any columns which meet the condition which
populates the array, is there a quick way to determine that the array is
still empty?
Ubound(arIntArray) fails, becuase it's undefined. Is Nothing and Null also
produced errors.
If needed, I can put in a Boolean flag to set if the array gets populated,
but it seems like there is likely another way.
Thanks.
Mark
|