Skip to main content

Range.Summary property

Table of contents
  1. Syntax
  2. Example

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



expression A variable that represents a Range object.


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

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>