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.

alt text


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