Is a function or a number behind a cell?

S

steven

Lets say that in column A there are several typed in numbers (2, 5, 8 ect)
and some functions that result in a number. By looking at this sheet you
cannot tell wether there is a typed in number of function behind a cell.

Is there a function that i can put in column B that can tell you weather a
the cell right next to it in column A is a typed in number of a function?

thank you,

bay
 
B

Bob Phillips

Create a UDF

Function IsFormula(rng As Range)
If rng.Count > 1 Then
IsFormula = CVErr(xlErrRef)
Else
IsFormula = rng.HasFormula
End If
End Function

and use that

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top