Spreadsheet.MergeCasesEx

Extended case data merge.

Syntax Parameters Return Value 
Function Spreadsheet.MergeCasesEx( _
    Optional Input As Variant = 0, _
    Optional Recode As SpreadsheetType4 = scMergeAdjustText, _
    Optional OutputVariables1 As Variant = 0, _
    Optional OutputVariables2 As Variant = 0, _
    Optional selectionIncludeExpression1 As String = "", _
    Optional selectionIncludeList1 As String = "", _
    Optional selectionExcludeExpression1 As String = "", _
    Optional selectionExcludeList1 As String = "", _
    Optional selectionIncludeExpression2 As String = "", _
    Optional selectionIncludeList2 As String = "", _
    Optional selectionExcludeExpression2 As String = "", _
    Optional selectionExcludeList2 As String = "", _
    Optional MatchByVarName As Boolean = False, _
    Optional CopyFormatting1 As Boolean = False, _
    Optional CopyFormatting2 As Boolean = False, _
    Optional CreateSpreadsheet As Boolean = True) As Spreadsheet
  • Input [in,optional]

Type: Variant

Default value: 0

  • Recode [in,optional]

Type: SpreadsheetType4

Default value: scMergeAdjustText

  • OutputVariables1 [in,optional]

Type: Variant

Default value: 0

  • OutputVariables2 [in,optional]

Type: Variant

Default value: 0

  • selectionIncludeExpression1 [in,optional]

Type: String

Default value: ""

  • selectionIncludeList1 [in,optional]

Type: String

Default value: ""

  • selectionExcludeExpression1 [in,optional]

Type: String

Default value: ""

  • selectionExcludeList1 [in,optional]

Type: String

Default value: ""

  • selectionIncludeExpression2 [in,optional]

Type: String

Default value: ""

  • selectionIncludeList2 [in,optional]

Type: String

Default value: ""

  • selectionExcludeExpression2 [in,optional]

Type: String

Default value: ""

  • selectionExcludeList2 [in,optional]

Type: String

Default value: ""

  • MatchByVarName [in,optional]

Type: Boolean

Default value: False

  • CopyFormatting1 [in,optional]

Type: Boolean

Default value: False

  • CopyFormatting2 [in,optional]

Type: Boolean

Default value: False

  • CreateSpreadsheet [in,optional]

Type: Boolean

Default value: True

Spreadsheet