Excel Help

[horsesystemagic]

Hi All

Yet another challenge.
What I trying to achieve is for excel to fire another bet what a green up has been sucessful.
What I trying to do is to clear the bet reference and bet time Cells so it refire the original bet again.
What I am doing is pointing to the profit /loss cells and if it showing a profit in all cells for example X5:X30 then to clear cells T5:U30.
Is this possible? Also I would like to place a stop on betting after -60 seconds, wether inplay or not?

Thanks in advance. This Forum is so full of information keep up the great work.

Regards Shaune

[osknows]

This should be close but is untested

Code: Select all

Sub test()

With Sheet1
    timetext = Replace(.Range("d2").Value, "-", "")
    If InStr(1, .Range("d2").Value, "-", vbTextCompare) > 0 And ((Hour(timetext) * 60 * 60) + (Minute(timetext) * 60) + Second(timetext)) >= 60 Then
   
    'do nothing
   
    Else
   
    'clear if range in profit and bet ref exists
    If Application.WorksheetFunction.CountA(.Range("T5:T55")) > 0 And Application.WorksheetFunction.CountIf(.Range("X5:X55"), "<0") = 0 Then
   
    .Range("T5:U55").ClearContents
    End If
   
    End If
End With

End Sub