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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family