How to know a cell contain the formula

  • Thread starter Thread starter Andri
  • Start date Start date
A

Andri

Dear All,

Please help for the above subject, which formula to be used?

Thank you for your kind attention and help.

Have a nice weekend.

Respectfully,
 
Have a simple UDF

Function IsFormula(rng as range)

If rng.Cells.Count = 1 Then

IsFormula = rng.HasFormula
End If
End Function

and use like so

=Isformula(B1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Andri
I see you are requesting a formula but if you just need to see if there is a
formula, you can
Press on Ctrl+` (Accent grave) key before number 1 key to hide/unhide
formulas.
HTH
Cimjet
 
Dear Cimjet,

thank you for the response.
I need the formula to know certain cell either contains a formula or just a
value.

I will try to use the simple VBA given by Bob Philips.

Thank you for your kind attention and help.

Respectfully,
Andri
 
Dear Bob,

Thank you and it works properly.
So i can indicate if spesific cell contains just a formula or value.

have a great weekend.

respectfully,
Andri
 
Back
Top