Here is the msdn page for the function:
https://msdn.microsoft.com/en-us/vba/ex ... thod-excel
The page describes the parameter as a Variant type of "An array of 1-based field offsets, indicating the fields to which the subtotals are added. For more information, see the example."
Here's what I came up with:
safeArr := ComObjArray(12, 2)
safeArr := 5
safeArr := 6
ws.Range("L2:M3").Value := safeArr
ws.Range("B1:F4649").Subtotal(1, -4157, safeArr)
Assigning the array works fine which means it really is of variant type, however the Subtotal command won't accept the array as a parameter. Anyone might have an idea to make this work?