array

[Guest]

In one module, I have written 3 VBA functions.
In each VBA function I have 10 arrays as follow:
Dim Aarr() As Variant: Aarr = Array("a", "¸b", "c", "d")
Dim Barr() As Variant: Barr = Array("aa", "¸bb", "cc", "dd")
Etc…
The 10 arrays are exactly the same for the 3 functions and I repeat them for
each function.
Is there away to write only once the arrays in the module in order to work
for the 3 VBA functions?

Τhanks, for the answer.

 

[Bob Phillips]

Declare the variables as private variables before the 3 functions, they will
then be in scope of all 3

Private Aarr() As Variant
etc.

Sub rtn1()
....
End Sub

and so on

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dr. Stephan Kassanke]

In one module, I have written 3 VBA functions.
In each VBA function I have 10 arrays as follow:
Dim Aarr() As Variant: Aarr = Array("a", "¸b", "c", "d")
Dim Barr() As Variant: Barr = Array("aa", "¸bb", "cc", "dd")
Etc.
The 10 arrays are exactly the same for the 3 functions and I repeat them
for
each function.
Is there away to write only once the arrays in the module in order to work
for the 3 VBA functions?

Declare the arrays on module level instead of declaring them for each
function, thus you will get public variables.

cheers,
Stephan