TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?
 

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 ***

TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?
 

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

Jim Thomlinson


"jay dean" wrote:

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 ***

TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?
 

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 (MVP - Excel)


"Jim Thomlinson" wrote in message
...
There is no function for that. You need to traverse the array checking
each
element.
--
HTH...

Jim Thomlinson


"jay dean" wrote:

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 ***

TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?
 

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

Jay Dean

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