Spreadsheet.MergeVariablesCartesian

Cartesian variables merge. Defaults to all output variables, no selection conditions, no formatting, and spreadsheet creation.

Syntax Parameters Return Value 
Function Spreadsheet.MergeVariablesCartesian( _
    Optional Input As Variant = 0, _
    Optional OutputVariables1 As Variant = "", _
    Optional OutputVariables2 As Variant = "", _
    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 CopyFormatting1 As Boolean = False, _
    Optional CopyFormatting2 As Boolean = False, _
    Optional CreateSpreadsheet As Boolean = True) As Spreadsheet
  • Input [in,optional]

Type: Variant

Default value: 0

  • OutputVariables1 [in,optional]

Type: Variant

Default value: ""

  • OutputVariables2 [in,optional]

Type: Variant

Default value: ""

  • 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: ""

  • 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