StaSpreadsheetCompareType Enumeration

Specifies the Spreadsheet compare type.

Syntax Constants 
Enum StaSpreadsheetCompareType
    staCompareNumeric = 0
    staCompareText = 1
    staCompareAuto = 2
End Enum
  • staCompareNumeric: Compare numerically.
  • staCompareText: Compare textually.
  • staCompareAuto: Auto determine compare type. Numeric variables numerically, Text variables textually, and auto determine for numeric variables with text labels.