<div>
Tks. There is a logical bug in my program and I haven't erase it when the program is rerun again, Tks
</div>


Tks. There is a logical bug in my program and I haven't erase it when the program is rerun again, Tks

<div>
<div class="content wysiwyg-content">
I have defined a 2D array <br />
<br />
Dim myArray (1 To 20, 1 To 3)<br />
<br />
erase myArray<br />
<br />
It seems that the content of the array can't be erased. I need to clear its content when the invoice number is changed. Any idea ?<br />
<br />
Tks
</div>
</div>


I have defined a 2D array 

Dim myArray (1 To 20, 1 To 3)

erase myArray

It seems that the content of the array can't be erased. I need to clear its content when the invoice number is changed. Any idea ?

Tks

Erase array content with VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.