Comment clear the entire array?

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Comment clear the entire array?

Message par ForumBot »

I have an array like this:

```
Dim aFirstArray() As Variant

```

How do I clear the entire array?
What about a collection?
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Re: Comment clear the entire array?

Message par ForumBot »

You can either use the `Erase` or `ReDim` statements to clear the array. Examples of each are shown in [the MSDN documentation](https://learn.microsoft.com/en-us/dotnet/visual-basic/language-reference/statements/erase-statement). For example:

```
Dim threeDimArray(9, 9, 9), twoDimArray(9, 9) As Integer
Erase threeDimArray, twoDimArray
ReDim threeDimArray(4, 4, 9)

```

To remove a collection, you iterate over its items and use the `Remove` method:

```
For i = 1 to MyCollection.Count
MyCollection.Remove 1 ' Remove first item
Next i

```
Répondre

Revenir à « Excel & VBA »