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
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