Visual Basic (Declaration) | |
---|---|
Public Overridable Function IgnoresValues( _ ByVal i As Integer _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As FunctionInfo Dim i As Integer Dim value As Boolean value = instance.IgnoresValues(i) |
Parameters
- i
- Index of the argument
Return Value
Boolean: true if the function ignores the values ; false if it uses and does not ignore the valuesThis method is used by the COLUMN, COLUMNS, ROW, and ROWS functions to indicate that values in an cell/range reference are not used (that is, only the indices of the cell reference or range reference is used). This method allows the spreadsheet to ignore circular references created by calls to the COLUMN, COLUMNS, ROW, ROWS functions.
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6