HasFormula Property Example

This example recalculates the active worksheet if any cell on the worksheet contains a formula.

hf = Spreadsheet1.ActiveSheet.Cells.HasFormula
If IsNull(hf) Or hf Then Spreadsheet1.ActiveSheet.Calculate