Share via

CustomView.RowColSettings Property

  • Article
Excel Developer Reference

True if the custom view includes settings for hidden rows and columns (including filter information). Read-only Boolean.

Syntax

expression.RowColSettings

expression   A variable that represents a CustomView object.

Example

This example creates a list of the custom views in the active workbook and their print settings and row and column settings.

Visual Basic for Applications 
  With Worksheets(1)
    .Cells(1,1).Value = "Name"
    .Cells(1,2).Value = "Print Settings"
    .Cells(1,3).Value = "RowColSettings"
    rw = 0
    For Each v In ActiveWorkbook.CustomViews
        rw = rw + 1
        .Cells(rw, 1).Value = v.Name
        .Cells(rw, 2).Value = v.PrintSettings
        .Cells(rw, 3).Value = v.RowColSettings
    Next
End With

See Also