NUMBERFORMATGET

Returns whether a particular cell contains a formula.

'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.



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