Hi,

I have an array created in one procedure that I would like to use in another
procedure. How can I make the array in first procedure available in other
procedures?

TIA

Torbjorn

Torbjorn,

Declare the array as a public variable, prior to and outside of any
procedure in the module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Torbjörn Steijer" wrote in message
...
Hi,

I have an array created in one procedure that I would like to use in
another
procedure. How can I make the array in first procedure available in other
procedures?

TIA

Torbjorn

Or you could pass it as a variant argument e.g.

Sub Proc1()
Proc2 Array("Hello")
End Sub

Sub Proc2(ByVal ArgArray As Variant)
MsgBox ArgArray(0)
End Sub


"Chip Pearson" wrote in message ...
Torbjorn,

Declare the array as a public variable, prior to and outside of any
procedure in the module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Torbjörn Steijer" wrote in message
...
Hi,

I have an array created in one procedure that I would like to use in
another
procedure. How can I make the array in first procedure available in other
procedures?

TIA

Torbjorn