place another bet

[alrodopial]

It may be easy.
I place a bet in running which is matched or if it's not matched (or partially) it is cancelled after few secs.
So in excel,in column with the bet ref there is a number or "cancel".
what is the easiest way to clear this flag so I can place another bet in the same selection?
Do I need vba for this?

[mak]

Hi Al
if at bet ref there is CANCELLED you can use Gary code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
Application.EnableEvents = False
With Range("t5:t54")
Set c = .Find("CANCELLED", LookIn:=xlValues)
If Not c Is Nothing Then
firstaddress = c.Address
Do
c.Value = ""
Set c = .FindNext(c)
If Not c Is Nothing Then
If c.Address = firstaddress Then c = Nothing
End If
Loop While Not c Is Nothing
End If
End With
Application.EnableEvents = True
End If
End Sub



If there is a number you can use an if statement like
=if(T5>0,"CLEAR",...your trigger...)

[alrodopial]

Thanks