Expand Minimize

Range.Summary Property (Excel)

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

expression .Summary

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
© 2014 Microsoft