Sub

[brucelee]

i have a sub and i have problems with using arrays in it.
my sub needs to use an array which belongs to the whole app
and to build another array which the app will use later

i don't know how to define the arrays, please help

[Iain17]

OK. You will need two global, or form level arrays then. Sound like you want the sub to return an array, so maybe a function would be better.

Pass the 1st array to the function, and return the new one.

Private Function newArray(myArray() As String) as String()
  'code
End Function

'to call
myNewArray = newArray(my1stArray)