Built-in-Function checking Array of Zero Length

Anyone knows if there is a built-in-function in VBA checking if an array has zero length or not.

I have tried:
* LBound - Creates an error if the array is zero length which I want to avoid
* IsArray() - Always TRUE indpendent of zero length or not
* InNull() - Always FALSE indpendent of zero length or not

I have written a function bQuery_ArrayZeroLength() using LBound() with error handling which works. Code pasted below. I just want to know if there is a built-in-function for this.

Run Sub MyTest() below to execute code.

Please Login or Register  to view this content.

OK.

I have created a function that returns a dynamic array. The returned array can be of zero length. I can add an argument in this function using ByRef that returns the size of the array.

Originally Posted by Norie

I don't know of an inbuilt function for this, I normally use something connected with the population of the array.

For example if the array is dynamic and we are resizing it we would use a variable for the dimension, if that variable is 0 after the code that's mean to populate the array then you know the array is empty.

Something like this might work checking if a dynamic array is sized or not.

Please Login or Register  to view this content.

Originally Posted by Izandol

Simple test of Lbound or Ubound is not sufficient. For example if you will use Filter function on array that does not contain the item for which you filter, array will be returned with Lbound 0 and Ubound -1. It is better to test if Ubound (or LBound) returns error (if so, array is empty) then if no error, test if Lbound is lower than UBound - if not, array is also empty.