Syntax
| 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 valuesRemarks
This 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.
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2