<div>
<div class="content wysiwyg-content">
VBA - I'm using some global arrays so that they persist.<br />
eg. I put this in the top of the Module.<br />

<pre><code id="code-10-29086283-1">Public arrSections() As String</code></pre>
<br />
I would need to 'empty' it at certain points. How can I do that please?
</div>
</div>


VBA - I'm using some global arrays so that they persist.
eg. I put this in the top of the Module.
(CODE)

I would need to 'empty' it at certain points. How can I do that please?

VBA - Re-initializing a global Array

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.