Spreadsheet.SubsetRandomSamplingEx2

This property creates a new spreadsheet containing the specified subset of the current spreadsheet using selection conditions and Random Sampling.

This property is read only.

Syntax Parameters Return Value 
ReadOnly Property Spreadsheet.SubsetRandomSamplingEx2( _
    Variables As Variant, _
    selectionIncludeExpression As String, _
    selectionIncludeList As String, _
    selectionExcludeExpression As String, _
    selectionExcludeList As String, _
    samplingType As RandomSamplingType, _
    PctOrNumberOfCases As Double, _
    Optional bQuickRand As Boolean = True, _
    Optional bWithReplacement As Boolean = False, _
    Optional bUseSpreadsheetCaseWeights As Boolean = False, _
    Optional bExactN As Boolean = False, _
    Optional CopyFormatting As Boolean = False) As Spreadsheet
  • Variables [in]

Type: Variant

  • selectionIncludeExpression [in]

Type: String

  • selectionIncludeList [in]

Type: String

  • selectionExcludeExpression [in]

Type: String

  • selectionExcludeList [in]

Type: String

  • samplingType [in]

Type: RandomSamplingType

  • PctOrNumberOfCases [in]

Type: Double

  • bQuickRand [in,optional]

Type: Boolean

Default value: True

  • bWithReplacement [in,optional]

Type: Boolean

Default value: False

  • bUseSpreadsheetCaseWeights [in,optional]

Type: Boolean

Default value: False

  • bExactN [in,optional]

Type: Boolean

Default value: False

  • CopyFormatting [in,optional]

Type: Boolean

Default value: False

Spreadsheet