Delete VBA array content

There is an easy way to delete the contents of an array. Is possible by the command Erase

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

Option Explicit

Sub FeldBeispiel()
Dim fFeld(5, 5) As Integer

fFeld(3, 3) = 3
MsgBox fFeld(3, 3)
Erase fFeld
MsgBox fFeld(3, 3)

End Sub

These posts might also be interesting:

• Load VBA code from a text file
• Create own Excel formula
• How to convert a text field into a date field with VBA
• Using SAPGetVariable with VBA

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.