Syntax

expression.Add(ViewName, PrintSettings, RowColSettings)

expression A variable that represents a CustomViews object.

Parameters

Name Required/Optional Data Type Description
ViewName Required String The name of the new view.
PrintSettings Optional Variant True to include print settings in the custom view.
RowColSettings Optional Variant True to include settings for hidden rows and columns (including filter information) in the custom view.

Return Value
A object that represents the new custom view.

Example

This example creates a new custom view named "Summary" in the active workbook.

Visual Basic for Applications
ActiveWorkbook.CustomViews.Add "Summary", True, True

See also: