Subtotals Method

Applies To

PivotField object.

Description

Returns or sets subtotals displayed with the specified field. Valid only for nondata fields.

Syntax

expression.Subtotals(Index)

Use the Add method to add data validation to a range and create a new Validation object. The following example adds data validation to cell E5.

With Range("E5").Validation
    .Add Type:=xlValidateWholeNumber, _
        AlertStyle:=xlValidAlertInformation, Minimum:="5", Maximum:="10"
    .InputTitle = "Integers"
    .ErrorTitle = "Integers"
    .InputMessage = "Enter an integer from five to ten"
    .ErrorMessage = "You must enter a number from five to ten"
End With

Properties

AlertStyle property, Application property, Creator property, ErrorMessage property, ErrorTitle property, Formula1 property, Formula2 property, IgnoreBlank property, IMEMode property, InCellDropdown property, InputMessage property, InputTitle property, Operator property, Parent property, ShowError property, ShowInput property, Type property, Value property.

Methods

Add method (Validation object), Delete method, Modify method (Validation object).