Excel automation - subtotals

// Where XL is a workbook open using Excel automation

// and workbook with a data matrix is open

XLsum is int = -4157 // cannot just use -4157 as a parameter of the subtotal function

arrColumns is array of int 

    // Add subtotals

arrColumns = [8,9,10]

// this does not work - error "unable to find subtotal property of range"

//XL>>Sheets(n)>>Range("Data")>>Subtotal(1,-4157,arrColumns,True,False,True)  // -4157 = xlsum

// this works :)

XL>>Sheets(n)>>Range("A1")>>Subtotal(1,XLsum,arrColumns,True,False,True)  // -4157 = xlsum