Generates a list of cells containing formulas that refer to hidden cells as part of its calculation range. A hidden cell is any cell in a hidden sheet, row, or column.
Generates a list of cells containing formulas that produce a numeric value. For example, the formula: '=SUM(A1:C1)' will ...
Generates a list of cells containing formulas that produce a textual value. For example, the formula: '="Today is "&TEXT(NOW(),"dddd")' ...
Generates a list of cells containing formulas that refer to blank cells as part of its calculation range. A blank cell is ...
Generates a list of cells containing formulas that refer to external workbooks in their formulas. For example, a formula ...
Generates a list of cells containing formulas that refer to hidden cells as part of its calculation range. A hidden cell ...
Generates a list of cells containing formulas that refer to textual cells as part of its calculation range. A textual cell ...
Generates a list of cells containing formulas that start with a '+' character. For example, a formula such as: '=+B25' is ...
Generates a list of cells containing formulas that start with a '-' character. For example, a formula such as: '=-B25' is ...
Generates a list of cells containing formulas with errors. On the spreadsheet, Excel will show the value of these cells as ...