Spreadsheet.FilterCases

Sub Spreadsheet.FilterCases( _
    UseCaseName As Boolean, _
    Optional Variables As Variant = "*", _
    Optional OutputVariables As Variant = "*", _
    Optional UseSpreadsheetSelCond As Boolean = True, _
    Optional selectionIncludeExpression As String, _
    Optional selectionIncludeList As String, _
    Optional selectionExcludeExpression As String, _
    Optional selectionExcludeList As String, _
    Optional Sorted As Boolean = True, _
    Optional PreserveOrder As Boolean = False, _
    Optional CopyFormatting As Boolean = False, _
    Optional CreateFilteredSpreadsheet As Boolean = True, _
    Optional ByRef FilteredSpreadsheet As Spreadsheet, _
    Optional CreateDuplicatesSpreadsheet As Boolean, _
    Optional ByRef DuplicatesSpreadsheet As Spreadsheet)

• UseCaseName [in]

Type: Boolean

• Variables [in,optional]

Type: Variant

Default value: "*"

• OutputVariables [in,optional]

Type: Variant

Default value: "*"

• UseSpreadsheetSelCond [in,optional]

Type: Boolean

Default value: True

• selectionIncludeExpression [in,optional]

Type: String

• selectionIncludeList [in,optional]

Type: String

• selectionExcludeExpression [in,optional]

Type: String

• selectionExcludeList [in,optional]

Type: String

• Sorted [in,optional]

Type: Boolean

Default value: True

• PreserveOrder [in,optional]

Type: Boolean

Default value: False

• CopyFormatting [in,optional]

Type: Boolean

Default value: False

• CreateFilteredSpreadsheet [in,optional]

Type: Boolean

Default value: True

• FilteredSpreadsheet [out,optional]

Type: Spreadsheet

• CreateDuplicatesSpreadsheet [in,optional]

Type: Boolean

• DuplicatesSpreadsheet [out,optional]

Type: Spreadsheet