Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Comment clear the entire array?

ayi

I have an array like this:
<pre><code class="lang-auto">Dim aFirstArray() As Variant

</code></pre>
How do I clear the entire array? 
What about a collection?

ayi_2

You can either use the <code>Erase</code> or <code>ReDim</code> statements to clear the array. Examples of each are shown in <a href="https://learn.microsoft.com/en-us/dotnet/visual-basic/language-reference/statements/erase-statement">the MSDN documentation</a>. For example:
<pre><code class="lang-auto">Dim threeDimArray(9, 9, 9), twoDimArray(9, 9) As Integer
Erase threeDimArray, twoDimArray
ReDim threeDimArray(4, 4, 9)

</code></pre>
To remove a collection, you iterate over its items and use the <code>Remove</code> method:
<pre><code class="lang-auto">For i = 1 to MyCollection.Count
MyCollection.Remove 1 ' Remove first item
Next i

</code></pre>