I know they all are criminals(a specific datatype) But dont know how many?

[prabhafriend]

How to pass a dynamic array of “strings” to a function as an argument?

[GTO]

Guessing a bit here, but if you mean the number of strings you want to pass is dynamic, try ParamArray. See vba help and not that it must be the last arg and a variant.


Sub exa()
Call test("one")
Call test("One", "Two")
End Sub

Function test(ParamArray MyStrings() As Variant)
Dim i As Long

For i = LBound(MyStrings) To UBound(MyStrings)
MsgBox MyStrings(i)
Next
End Function


Hope that helps,

Mark

[prabhafriend]

We can't specify the datatype here. Because It will create complexities in Validations. Thank you.

[Paul_Hossler]

Worksheet function or VBA function?

Paul

[SamT]

I think he wants to pass a dynamic array to a sub as a By Ref.
ie.

Sub SomeSub()
Dim SomeDynamicArray as String
MySub SomeDynamicArray
End Sub

Sub MySub(MyArray)
Do Something with MyArray 'SomeDynamicArray
End Sub