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.

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