>I would like to call the Excel SubTotal method thru a VFP ActiveX Automation call.
>
>I understand how to pass all the parameters the method is looking for except one that is an array of the column numbers to subtotal on.
>
>Can anyone suggest how to pass arrays from VFP to Excel that I can use for this purpose?
>
>Thanks!

Does not passing the array by reference work?

exPression.SubTotal(nGroupBy, nFunction, @laTotalList)