Check whether a cell has a formula, eg =hasformula(A1)

Function HasFormula(C As Range) As Boolean
 HasFormula = C.HasFormula
End Function


© Copyright andrewsexceltips.net All Rights Reserved.