Detecting empty array

[AlexanderBB]

Dim fn as Variant
I've filtered my array and this may have removed all items.
But IsEmpty(fn) returns False and ? fn(0) gives subscript out of range.
Error handling works but is there a correct 'Excel' way to handle this?

 

[Joe4]

Have a look here: VBA Array Length (Size).

 

[Micron]

Problem is kinda sketchy. Can't tel if fn is the initial array or the filtered one. Or if the same variable is used for both.
A variant is both 0 and "" when it is initialized but I'm not sure if ?fn(0) should return that error if the only value in the array variable is "" or 0.
Or maybe Option Base 1 is set, which would make the first element 1, not 0.
Or I misunderstood what the problem is.

 

[Peter_SSs]

I've filtered my array and this may have removed all items.

Something like this?

If UBound(fn) = -1 Then MsgBox "You filtered everything out"

 

[AlexanderBB]

Thanks for the replies, Ubound = -1 was what I'd missed. And then For e = Lbound(fn) to Ubound(fn) seems to do the trick.

 

[Alex Blakenburg]

@Joe4 & @Micron - what Peter picked up on and I certainly didn't was that the OP must have used VBA filter of an array.
Something like this:

   filterArr = Filter(arr, "Value_to_Filter_On")

If nothing is found it produces this:

Note:
IsEmpty produced False
IsArray produced True