A function to indicate whether a cell contains formula or value?
 

Is there a function to return logical indication of whether a cell contains
formula or value? Need it for conditional cell formating.

A function to indicate whether a cell contains formula or value?
 

Not built in

http://www.mvps.org/dmcritchie/excel...htm#HasFormula

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Dave T" <Dave wrote in message
...
Is there a function to return logical indication of whether a cell
contains
formula or value? Need it for conditional cell formating.

A function to indicate whether a cell contains formula or value?
 

With a User Defined Function such as

Function IsFormula(cell)
Application.Volatile
IsFormula = cell.HasFormula
End Function


Gord Dibben MS Excel MVP

On Wed, 7 Jun 2006 13:18:02 -0700, Dave T <Dave
wrote:

Is there a function to return logical indication of whether a cell contains
formula or value? Need it for conditional cell formating.