If you declare an array variable, then set it using Array() then pass the variable into your function, VBA will be happy. Sub test() Dim ... ... <看更多>

In Today's Video, We will create a function and ParamArray will be pass as argument in same.The ParamArray argument makes it possible for a ... ... <看更多>

Passing by reference means that any changes to the array will be preserved in the calling proceedure. Sub testArrayPassing() Dim source(0 To 1) ... ... <看更多>

VBA I am pretty good at, but the API thing is brand new. Thanks again for your excellent help! ... <看更多>

The Current code is testing i but passing j in as a parameter. ... Public Sub ReversibleQuickSort(ByRef arrySource As Variant, ... ... <看更多>