View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Dean Jay Dean is offline
external usenet poster
 
Posts: 154
Default 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 ***