Thread: Public Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent McIntyre Brent McIntyre is offline
external usenet poster
 
Posts: 23
Default Public Array

To whom it may concern,

I am trying to set a multi dimensional array that can be updated by all
procedures then exported at the end. Does anyone know if I can do this
?

ie

Private Sub UPDATE1()
Set MultiDimensionalArray(1,0) = "Frank"
End Sub

Private Sub UPDATE2()
MultiDimensionalArray(1,1) = "Megan"
End Sub

Public Sub MultiDimensionalArray()
End Sub

Any help you may be able to provide would be much appreciated.

Yours sincerely,

Brent McIntyre

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!