CustomView.RowColSettings Property - Microsoft Office Excel

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

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`

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

Find out if a custom view includes hidden row settings? row col settings Row Col Settings Property rowcol RowColSettings RowColSettings Property

See also: