If array is empty - condition VBA

[Kristina96]

Hello there,

I need a contiditon that checks whether an array Ary1 is empty in VBA.
Can you help me with that?

Thank you and best regrads,
Kristina

 

[mikerickson]

How has Ary1 been dimensioned? If it has been declared as a data type (Long, Double, String, Boolean, etc.) and given dimensions, then it will be filled with the default for that data type.

 

[Norie]

How is Ary1 being populated?

 

[Kristina96]

It is dim As Variant and includes a list of strings or is empty.
Does that answer the question? I am still rather new to VBA, so please excuse my missing background knowledge!

Thank you!

 

[Norie]

Can you post your current code?