StaSpreadsheet.IsValidFormula

This function verifies the well-formedness of a specified formula.

Syntax Parameters Return Value
Function StaSpreadsheet.IsValidFormula( _
    bstr As String, _
    Optional ByRef errormsg As Variant, _
    Optional ByRef varsInUse As Variant, _
    Optional ByRef errPosBegin As Variant, _
    Optional ByRef errPosEnd As Variant) As Boolean
  • bstr [in]

Type: String

  • errormsg [out,optional]

Type: Variant

  • varsInUse [out,optional]

Type: Variant

  • errPosBegin [out,optional]

Type: Variant

  • errPosEnd [out,optional]

Type: Variant

Boolean