In VBA, how can I set an Array to Empty?

Question

Now, before you say it - I've read dozens of similar topics, and couldn't find a solution. I have a dynamic Variant array, which has to be completely cleared, so it is regarded as Empty during IsEmpty check. I tried Erase, but IsEmpty still returns False. I can't ReDim it, because the array is dynamic. Tried to set whole array to Nothing, but that throws an error during IsEmpty check.

What am I doing wrong, and how can I completely eradicate that array, so the IsEmpty would return True?

Can you show relevant codes in your question? Edit it please. — Raptor
– Raptor, Commented Mar 19, 2018 at 1:45

andrew · Accepted Answer · 2018-03-19 01:51:21Z

You can assign the keyword Empty to a Variant variable.

Public Sub Hello() Dim vArray As Variant vArray = Array("a", "b", "c") Debug.Print IsEmpty(vArray) 'prints false vArray = Empty Debug.Print IsEmpty(vArray) 'prints true End Sub

Krutorek · Accepted Answer · 2023-12-24 16:17:38Z

2

You can use Erase statement.

Erase vArray

answered Dec 24, 2023 at 16:17

Krutorek

211 bronze badge

Collectives™ on Stack Overflow

In VBA, how can I set an Array to Empty?

2 Answers 2

Comments

Comments

Hot Network Questions