Solved: Is there an ISnumeric or Formula code

[burley]

Excel 2003

Hi I have some code that works fine, which checks cells for a Value before carrying out some code. I would like it to check for a Value or a Formula rather than just a value.
Currently the code is:-

For Each cell In .Range("C7:IV214").SpecialCells(xlCellTypeConstants)

If IsNumeric(cell.Value) Then

Can anyone show me how a can change this to look for either a value or formula?

Thank you

Paul

[Bob Phillips]

SpecialCells has a formulas constnat that it can check for.