Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting a text strings but omitting preceding "A" or "The" | Excel Worksheet Functions | |||
=IF function, reference problem to "text strings" in Data Validati | Excel Discussion (Misc queries) | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
Listbox header inside VBA (Array("Head1", "Head2", ...) | Excel Programming | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |