TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?

[jay dean]

Hi -

I have a string array dimensioned as Myarr(20).
After operating on this array, some of its elements and eventually, each
of its elements will be set to empty string "".
How do I check that every single element of the array is ""? I tried
Isempty() and IsNull() but it doesn't seem to work.
Is there a vba boolean function that can check this?

Thanks
Jay

 

[Jim Thomlinson]

There is no function for that. You need to traverse the array checking each
element.

 

[Rick Rothstein]

Since the array is a String array, there is a simple way to do the test the
OP wants without looping through the array...

If Join(Myarr, "") = "" Then
' All elements are empty
Else
' At least one element has data in it
End If

 

[jay dean]

Rick, I think you have a natural gift of producing elegant solutions.
Thanks a boatload!!

Jay Dean