I'm getting this error

compile error : invalid or unqualified reference



If !IsNumeric((Cells(Row, 11).Value)) Then
Cells(Row, 11).Interior.ColorIndex = 4
End If


I just want to validate that the data in the cell is numeric.

Billy,

Remove the ! mark, then it should work.


If IsNumeric((Cells(Row, 11).Value)) Then
Cells(Row, 11).Interior.ColorIndex = 4
End If

Paul


"Billy" wrote in message
...

I'm getting this error

compile error : invalid or unqualified reference



If !IsNumeric((Cells(Row, 11).Value)) Then
Cells(Row, 11).Interior.ColorIndex = 4
End If


I just want to validate that the data in the cell is numeric.

figured it out


If Not IsNumeric

Sorry This should have read

If Not(IsNumeric((Cells(Row, 11).Value))) Then
Cells(Row, 11).Interior.ColorIndex = 4
End If

as you are testing for non-numeric values.
Paul


"Billy" wrote in message
...

I'm getting this error

compile error : invalid or unqualified reference



If !IsNumeric((Cells(Row, 11).Value)) Then
Cells(Row, 11).Interior.ColorIndex = 4
End If


I just want to validate that the data in the cell is numeric.