Mark and NoUse4aName and others wishing to join,
I don't know what element has a non blank value.
myArray(2345,2001) = "not blank"
i need to know if any element is not empty or ""
Is there a way to find out if any element has a value besides using
type of code.
Dim inner, outer,hold
For inner = 0 to uBound(myArray,1)
For outer = 0 to uBound(myArray,2)
hold = myArray(inner,outer)
if hold <> empty or hold <> "" then
msgbox "found one"
i realize that getting into this situation was not good in the first place. I know a lot of other ways to avoid this. Yet I am looking for a solution at this time.