XlSubtototalLocationType Enumeration

Specifies where the subtotal will be displayed on the worksheet.

Version Information
 Version Added:  Excel 2007

Name Value Description
xlAtBottom 2 Subtotal will be at the bottom.
xlAtTop 1 Subtotal will be at the top.