How do I pass an Array as a function argument?
Posted on 2004-09-18
I have created a function: HolidayList(ListID)
Using the ListID parameter, the function produces a recordset that I then use to populate an array. Then array contains dates associated with that nation's holidays.
The "HolidayList" function works. I've confirmed that the elements of the array are successfully populated and the HolidayList variable has a vartype of 8197 which I believe is an array with date elements.
The temporary variable name I assign to the array during the loop is "HL"
At the end of the function I set HolidayList = HL
I need to use the array in another function. Call this function "B"
I've tried passing the array to Function B like this:
Function B (arg1, arg2, ByRef HolidayList(1) as Variant)
FunctionB(arg1, arg2, HL as Variant)
Both return the error message: Comile Error: Typ Mismatch, array or user-defined type expected.
What do I need to do in order for the app to recognize HolidayList(1) as an array???
Having a wonderful time here saturday night...