Good way to handle empty arrays?

[OldManExcellor]

I have a dynamic array that is somethimes empty. I want to do an operation on all array elements in my code. When there are no array elements, I want the code to just continue.

But the two methods to loop array elements that I know of aren't skipped when the dynamic array is empty. The generate errors.

I have been able to handle this using OnError Resume Next. But I'm thinking maybe there is some smoother way to avoid getting errors when the dynamic array is empty?

Your help is very appreciated.

'Method 1
    For i = 0 To arrayCount
        Do stuff...
    Next i

'Method 2
    For Each currentElement In family
        Do stuff...
    Next

 

[Jameo]

Hi OldMan,


Take a look here:

http://www.cpearson.com/excel/VBAArrays.htm

Download the module and then add it to your workbook.

You will then be able to use the IsArrayEmpty function in an if statement to determine if the array is empty before calaculating it, thus solving the problem of your empty arrays. There are also a lot of other useful array based commands.