NUMBERFORMATGET
Returns whether a particular cell contains a formula.
Remarks
* 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.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext