- Code: Select all
If .Range("T" & matchRow) <> "PENDING" Then 'Bet has been processed
If .Range("T" & matchRow) <> vbNullString And IsNumeric(.Range("T" & matchRow)) = False Then 'Report is not a bet number - must be error
'Cancel Bets & Green Up
CGreen ("Report") 'Call green up routine
GoTo Finish
Else
'Carry on processing
End If
End If
However, this doesn't appear to be working as it's sometimes detecting an error when there isn't one. Is there a better way of doing this? I thought a non-numeric value in column T would indicate an error. TIA.