Excel IsFormula Function Alternative Formula

[MarkReddell]

Hello Mr. Excelers!!! I'm using Excel 2016, however @ work they're using Excel 2007. How do I write a formula alternative to the IsFormula Function??? Thanks 4 any help concerning my issue!!! God's Blessings!!!

 

[Trebor76]

Hi Mark,

The ISFORMULA function was released with Excel 2013. For previous versions you'll need a User Defined Function (UDF) like the following to do the same:

Option Explicit
Function HasFormula(reference As Range) As Boolean

    HasFormula = reference.HasFormula

End Function

So once installed you would use the above UDF in the same way as the ISFORMULA function i.e.

=HasFormula(B2)

will return TRUE if there's a formula in cell B2 or else it will return FALSE.

Regards,

Robert

 

[MarkReddell]

Thanx Robert for your reply!!! Question: Where do I Paste this code??? In the W/S or the W/B??? Robert Thanks again!!! It Worx!!!

 

[Trebor76]

It would go in the workbook (just like a standard macro) where you want to want use the UDF.