How to know a cell contain the formula

[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,

 

[Bob Phillips]

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)

 

[Cimjet]

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

 

[Andri]

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

 

[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