Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |