Prev: saving macro from workbook to Personal Macro Workbook
Next: How many entries can Excel handle!?
From: DoubleZ on 25 Mar 2010 14:27
Thank you Mike and Luke! I am surprised to hear that Excel does not have
that functionality built in, but at least it isn't a difficult UDF.

Thanks again.
DoubleZ

"Luke M" wrote:

> Unfortunately, no. You could use a short UDF to determine this though. To
> install the UDF, open the VBE (Alt+F11) and goto Insert, module. Paste the
> following in:
>
> '==========
> Function IsFormula(r As Range) As Boolean
> IsFormula = Left(r.Formula, 1) = "="
> End Function
> '==========
>
> Close the VBE, and back in your workbook, you can simply use the formula
> =IsFormula(A1)
> to check if a cell contains a formula or not.
>
> --
> Best Regards,
>
> Luke M
> "DoubleZ" <DoubleZ(a)discussions.microsoft.com> wrote in message
> news:25C1DBFA-B8D0-47DC-BEE0-54541A6B4B26(a)microsoft.com...
> > In excel 2007, is there a formula to determine whether or not a cell
> > contains
> > a formula? Basically I want to do and If/Then function that will return a
> > certain answer if a cell contains a formula and will return a different
> > answer if the cell only contains text (that was manually entered in).
> >
> > Thank you.
> > DoubleZ
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: saving macro from workbook to Personal Macro Workbook
Next: How many entries can Excel handle!?