Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
array
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) "??????? ?.?." wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
array
"??????? ?.?." schrieb im Newsbeitrag ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |