How to know a cell contain the formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andri - 28 Mar 2008 10:33 GMT

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,

Reply to this Message

Bob Phillips - 28 Mar 2008 11:46 GMT

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)

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Dear All,
>
[quoted text clipped - 5 lines]
>
> Respectfully,

Reply to this Message

Andri - 28 Mar 2008 13:49 GMT

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

> Have a simple UDF
>
[quoted text clipped - 19 lines]
> >
> > Respectfully,

Reply to this Message

Cimjet - 28 Mar 2008 12:56 GMT

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 All,
>
[quoted text clipped - 5 lines]
>
> Respectfully,

Reply to this Message

Andri - 28 Mar 2008 13:25 GMT

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

> Hi Andri
> I see you are requesting a formula but if you just need to see if there is a
[quoted text clipped - 13 lines]
> >
> > Respectfully,

Reply to this Message