DBTable.VerifyData

Verifies data by marking cases based on a range of cases and selection conditions.

Syntax Parameters Return Value
Sub DBTable.VerifyData( _
    Optional FirstRow As Long = 1, _
    Optional LastRow As Long = 0, _
    Optional ArrayValidCases As Variant, _
    Optional ArrayValidIf As Variant, _
    Optional ArrayInvalidCases As Variant, _
    Optional ArrayInvalidIf As Variant, _
    Optional VerifyCondition As SpreadsheetVerifyConditions = scVerifyAllConditions, _
    Optional ClearCurrent As Boolean = True, _
    Optional VerifyShow As SpreadsheetVerifyShow = scVerifyShowMarked)
  • FirstRow [in, optional]

    Type: Long

    Default value: 1

  • LastRow [in, optional]

    Type: Long

    Default value: 0

  • ArrayValidCases [in, optional]

    Type: Variant

  • ArrayValidIf [in, optional]

    Type: Variant

  • ArrayInvalidCases [in, optional]

    Type: Variant

  • ArrayInvalidIf [in, optional]

    Type: Variant

  • VerifyCondition [in, optional]

    Type: SpreadsheetVerifyConditions

    Default value: scVerifyAllConditions

  • ClearCurrent [in, optional]

    Type: Boolean

    Default value: True

  • VerifyShow [in, optional]

    Type: SpreadsheetVerifyShow

    Default value: scVerifyShowMarked

This function does not return a value.