Jenny,

Use the HasFormula property. For example

If Range("A1").HasFormula = True Then
Debug.Print "range has formula"
Else
Debug.Print "range doesn't have formula"
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jenny" wrote in message
...
How would I use code to identify a formula (vs. a plain
input number) in a cell.

Thanks.