How would I use code to identify a formula (vs. a plain input number) in a cell. Thanks.
J Jenny Jan 13, 2004 #1 How would I use code to identify a formula (vs. a plain input number) in a cell. Thanks.
C Chip Pearson Jan 13, 2004 #2 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, 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
