jagged array

[and0b]

Hi!
I have small problem with testing elements of array. Some of array elements are empty, some contains other arrays. Test
if aMyArray(3,101)= empty
works fine for empty elements but it is triggering runtime "Error #13: Type mismatch" for other elements. How can I determine which elements are empty which not?
I declared this array as variant.

Thanks for any help.

 

[Andrzejek]

Have you tried:

If Len(aMyArray(3,101)) = 0 Then

Have fun.

---- Andy

 

[and0b]

it works for empty elements, for elements contain arrays it is still generating error message #13.

 

[SBerthold]

Check first if the element is an array using IsArray(). If not, then check if empty.

If it is an array, then check the elements of that accordingly.

 

[Hypetia]

Instead of:
[tt]If aMyArray(3, 101) = Empty Then[/tt]
use:
[tt]If IsEmpty(aMyArray(3, 101)) Then[/tt]

 

[and0b]

It worked.
Thank you!

Andrew