OFF97: How to Create and Use a Global Array in VBA Procedures

In Microsoft Visual Basic for Applications, you can create a dimensioned array, such as A(6,6), that is available to all procedures in all modules. This article includes sample Visual Basic for Applications routines that demonstrate how this can be...

support.microsoft.com