Generates a list of cells containing formulas that refer to blank cells as part of its calculation range. A blank cell is any cell that does not contain a formula or value.
Generates a list of cells containing formulas that produce a date/time value. For example, the formula: '=NOW()' will produce ...
Generates a list of cells containing formulas that produce a logical value. For example, the formula: '=TRUE' produces a ...
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 ...