View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_2_] Robert Crandal[_2_] is offline
external usenet poster
 
Posts: 158
Default Pass "array of strings" into a function??

I thought this would be easy to solve, but I am having trouble
finding information on how to define a VBA function (or sub)
that has an "array of strings" as an argument. Here is my
defintion so far:

Sub Sort_Array_of_Strings (ByRef Arr() As String)

' stuff in here

End Sub


Whenever I try passing an array of strings into this subroutine
I get a "type mismatch" type of error message.

Can anyone show me how to correctly pass an array of
strings into a function or sub? How do I define the function as well?

Thank you!