passing string array into a procedure

[GabKPK]

I have problem passing the array into a procedure, is my syntax correct? I am not very familiar with VBA.

Function func1(ParamArray array1())
.
.
.
func2(array1()) ' It is a string array.
.
end Function

sub func2(paramArray array2())
.
.
end sub

 

[JohnYingling]

ParamArray is a special purpuse constructin for a list of optional parameters. If you are passing a string array
Dim aryStr() As String
Redim aryStr(whatever)
then use
Function func1(array1() as string)
.
.
.
func2(array1()) ' It is a string array.
.
end Function

sub func2(array2() as string)
.
.
end sub

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript