>Is there a way to use the UBound function on a Dynamic Array? When I test the UBound of an array defined by Dim aAnyArray() As Variant I get a type mismatch error.

At some point, you have to have issued a ReDim, at which point, UBound() should work fine with Dynamic Arrays.