figured it out

dimension la1[1]
la1[1]=5  &&& means subtotal column 5
 oExcel.Selection.Subtotal(7, xlSum,@la1, True, False,  True)

>sorry, but I had forgotten...
>
>i want to use :
>
>
> oExcel.Selection.Subtotal(7, xlSum, Array(5), True, False, True)
>
>
>and don't remember what to do with the array(5) parameter
>
>
>Thanks
>
>
>Peter