Excel 2003 - can I tell if a cell contains a formula?

[dgillz]

I need to be able to test if a cell contains a formula or a static value. Is there a way to do this in VBA?

If cells(1,1).isFormula then
Do This
else
Do That
End if

Any insights appreciated.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

Answered my own question. Its the .HasFormula property.

If cells(1,1).HasFormula then
Do This
else
Do That
End if

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Gavona]

myRange.SpecialCells(xlCellTypeFormulas, 23)
A bit more to it - look up the Specialcells method in help

Gavin

 

[AnotherHiggins]

What are you planning on doing to Formulas that you aren't doing to other cells?

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.