Range.Summary Property

  • Article
Excel Developer Reference

True if the range is an outlining summary row or column. The range should be a row or a column. Read-only Variant.

Syntax

expression.Summary

expression   A variable that represents a Range object.

Example

This example formats row four on Sheet1 as bold and italic if it’s an outlining summary column.

Visual Basic for Applications 
  With Worksheets("Sheet1").Rows(4)
    If .Summary = True Then
        .Font.Bold = True
        .Font.Italic = True
    End If
End With

See Also