View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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