| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep an Array 'alive'
Hi there,
I have a Sub in a form, which runs when a commandbutton is pressed. In the Sub an array is dimmed and filled with values. e.g. Dim NANames(1 To 20, 0 To 2) I need the values of the Array in another Sub, but the array is only available in the specific Sub when created. Declaring it Public is not possible with an array, so I need another way of doing this. Anyone ? Thanks ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex conditional summing - array COUNT works, array SUM gives#VALUE | 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 | |||
| How to keep a Variable alive after a Call to Sub Routine | Excel Discussion (Misc queries) | |||
| variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
![Fred[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
