View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred[_17_] Fred[_17_] is offline
external usenet poster
 
Posts: 20
Default 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 !