DBTable.RankVariables

Ranks the specified range of variables in the spreadsheet.

Syntax Parameters Return Value
Sub DBTable.RankVariables( _
    Variables As Variant, _
    Optional Rank1 As RankAssignment = scRankSmallest, _
    Optional Ties As RankTieResolution = scRankMean, _
    Optional Type As RankType = scRankRegular, _
    Optional selectionIncludeExpression As String = "", _
    Optional selectionIncludeList As String = "", _
    Optional selectionExcludeExpression As String = "", _
    Optional selectionExcludeList As String = "", _
    Optional weightVar As Integer = 0)
  • Variables [in]

    Type: Variant

  • Rank1 [in, optional]

    Type: RankAssignment

    Default value: scRankSmallest

  • Ties [in, optional]

    Type: RankTieResolution

    Default value: scRankMean

  • Type [in, optional]

    Type: RankType

    Default value: scRankRegular

  • selectionIncludeExpression [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeList [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeExpression [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeList [in, optional]

    Type: String

    Default value: " "

  • weightVar [in, optional]

    Type: Integer

    Default value: 0

This function does not return a value.