VBA Excell, Global array/matrix

[gustaf111]

How do I declare and use a global array/matrix ?

 

[SkipVought]

hi,

Module level declaration...

Public YourArrayVar()

Sub SomeProcedure()
'.....
   ReDim Preserve YourArrayVar([i]...some dimensions ...[/i])
'.....
End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gustaf111]

Can I have an global array in a sheet ? Do I need Redim ? It worked for me without ...

 

[SkipVought]

The Public declaration in a Sheet module has only that sheet in scope. However a public declaration in a Module has global scope.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}