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. |
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 |