Thread: Highight cell with non numeric data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Billy[_7_] Billy[_7_] is offline
external usenet poster
  
Posts: 4
Default Highight cell with non numeric data

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.
Reply With QuoteReply With Quote