Testing a string array for any values
Based on the limited description of the situation I believe you would have
to loop through each element and compare it to a null string ("")
Since you have redim'd the array and haven't erased it, I don't think you
can check for anything against the array variable itself
If you have erased it that would be a different situation.
--
Regards,
Tom Ogilvy
"Chris W." wrote in message
...
Hi,
I have a dynamic, zero-based, string array that I Redim
often, and i want to know how do i test it to see if it
actually has any elements in it before I put it thru the
loop to extract the data. If I have no elements I want to
exit before looping. Can I use IsEmpty to test a string
Array or is it a "" value by default. I forget, and
documentation is sparse on details.
thank you
|