Get the value into a separate variable first, then compare with the variable. If you get the error, check the type. It is quite possible that the cell has a different data type, even if it looks like numeric.
>I am using this code snippet below and getting the operator/operand type mismatch error for
>this part:
>
>oExcel.Cells[nRow, 8].Value <= 3.2".
>
>
>code snippet:
>
>FOR nRow = 1 TO oExcel.ActiveWorkBook.ActiveSheet.UsedRange.Rows.Count
> IF (oExcel.Cells[nRow, 2].Value = "eseti" AND oExcel.Cells[nRow, 8].Value <= 3.2)
> oExcel.Cells[nRow, 2].Interior.Color = RGB(255,153,255)
> ENDIF
>ENDFOR
>
>
>Can anyone help?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
