How do you check whether a formula exists in a cell or not?

  • Thread starter Thread starter AllanW
  • Start date Start date
A

AllanW

I need to be able to check whether a cell contains a formula or not.
Does anyone know of a function which can perform this check?

Thanks.
 
Allan W

Control ` (Control Grave) shows all the formulas (on my computer the key
above the Tab)

Alan
 
Hi
you can use a UDF:
Function IsFormula(Cell As Range) As Boolean
IsFormula = Cell.HasFormula
End Function

HTH
Frank
 
One way to select all formulae is to use Edit > Goto > Special and the
to check the box for formula, unchecking any that are not required i.e.
Logical

This will highlight all formula cell, choose a fill colour and all
formula cells will be filled.

You could use a different fill colour for different types of formula.

HTH

Mike
 
I need to be able to check whether a cell contains a formula or not.
Does anyone know of a function which can perform this check?
Click to expand...

Strangely none of the information functions seem to show that (as far
as I can recall, anyway). However it's easy enough to build your own.
Copy this into a standard module:

Function DoesCellHaveFormula(rng As Range) As Boolean

If rng.HasFormula Then
DoesCellHaveFormula = True
End If

End Function

Then you can just use it as you would any other worksheet function,
like so:

=DoesCellHaveFormula(C4)
 
Back
Top