WorksheetFunction.IsFormula (Excel)

Checks whether a reference is to a cell containing a formula, and returns True or False.

IsFormula (Arg1)

Arg1: Reference to the cell that you want to test. Reference can be a cell reference, a formula, or a name that refers to a cell.

Dim booIsFormula As Boolean
booIsFormula = WorksheetFunction.IsFormula(Arg1:=)