TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?

  • Thread starter Thread starter jay dean
  • Start date Start date
J

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
 
There is no function for that. You need to traverse the array checking each
element.
 
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
 
Rick, I think you have a natural gift of producing elegant solutions.
Thanks a boatload!!

Jay Dean
 
Back
Top