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
* The equivalent JavaScript function is NUMBERFORMATGET

'rgeCell - The cell you want to check.

Public Function NUMBERFORMATGET(ByVal rgeCell As Range) As String

   NUMBERFORMATGET = rgeCell.NumberFormat
End Function

Calling this function IsFormula rather than HasFormula is in keeping with other Excel functions.

microsoft excel docs

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