TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?

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

*** Sent via Developersdex http://www.developersdex.com ***
 
J

Jim Thomlinson

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top