[AccessD] Excel Subtotal from Access/VBA

Is Subtotal a range name or an reserved object name? If a named range, it 
might not like that -- it's probably a reserved word. Never done subtotaling 
with VBA, so don't even know the object model for that.

Susan H.


> I'm not sure what's going on there but I always use the macro recorder in
> Excel, and crib the code it generates into my VBA.  I'd try that.
>
>
>        .Selection.Subtotal GroupBy:=4, Function:=xlSum,
> TotalList:=Array(12), _