Function with an array argument

[mbentley]

I want to create a function that accepts an array of values, rather than a predetermined number of arguments. Can anyone tell me the syntax for this?

Thanks

 

[Mile-O]

Private Function MyFunction(strArrays())

 

[mbentley]

Thanks. I actually figured this out and forgot to remove my post. I used the Param Array argument. It worked, but was that necessary?

 

[Mile-O]

If the array is explicitly declared then you can pass it as I mentioned.

i.e.

Dim myArray(1 To 10) As String


If its simply declared with no LBound or UBound then you pass it with the ParamArray argument.

i.e.

Dim myArray() As String