I have a Worksheet that clears the status cell O9 once bet is placed. It works great in draft but the command does not fire when connected to BA. I have tried slowing the refresh rate down to 3 secs but this makes no difference.
Any thoughts?
Clear Staus Cell O9
Make sure that L9 is cleared as well otherwise it will just try firing a bet again into the market and it will still display placed.
with objWS
if .range("O9") = "PLACED" Then
.range("L9").clearcontents
.range("O9").clearcontents
end if
end with
with objWS
if .range("O9") = "PLACED" Then
.range("L9").clearcontents
.range("O9").clearcontents
end if
end with