PDA

View Full Version : Solved: Is there an ISnumeric or Formula code



burley
03-27-2008, 07:35 AM
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
03-27-2008, 07:37 AM
SpecialCells has a formulas constnat that it can check for.