Returns whether a particular cell contains a formula.
For instructions on how to add a function to a workbook refer to the page under Inserting Functions

'rgeCell - The cell you want to check.

Public Function ISFORMULA(ByVal rgeCell As Range) As Boolean

   ISFORMULA = rgeCell.HasFormula
End Function
alt text

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext