Rediger

Del via

WorksheetFunction.Subtotal method (Excel)

  • Artikkel

Creates subtotals.

Syntax

expression.Subtotal (Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)

expression A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data type Description
Arg1 Required Double A number indicating the aggregation function to be used by the method.
Arg2 Required Range The first Range object for which a subtotal is to be calculated.
Arg3 - Arg30 Optional Variant Subsequent Range objects for which a subtotal is to be calculated.

Return value

A Double value that represents the subtotal.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.