Spreadsheet.VerifyData

This function verifies data by marking cases based on a range of cases and selection conditions.

Syntax Parameters Return Value 
Sub Spreadsheet.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.