I want to call a function several times, but pass in the array it's going to use each time.
I'm not sure how to do this. I thought i would just pass in the name of the array as a string, but i can't figure out how to use in something like:
 
Dim NDC11(5000) As String

this = "NDC11"

Function test(this As String)

this(counter) = ActiveCell.Value

End Function
I just need an example of how it would work. If anyone would have a better way to do it i would be grateful.

Thanks guys,

Chris