13:55 Newbury

[SWV]

Anyone know why the 13:55 Newbury didn't show as In Play/Suspended at the end of the race? Instead It displayed In Play/Closed.

I use In Play/Suspended the end of the race to trigger my sheet.

[alrodopial]

have it as InPlay+Suspended when finished, so it's ok at me
Maybe it's time to add another if in the code

[SWV]

1st time I’ve known this fail.

You have a suggestion for another If?

[alrodopial]

1. if(rngE2=In Play"and rngF2="Suspended") or if(rngE2=In Play"and rngF2="Closed") then race ended

2. Create a variable to store the previousStatus and compare it with currentStatus
if preStatus = "In Play" and ( rngF2="Suspended" or rnfF2="Closed") then race just ended
preStatus = currentStatus 'update variable , will be used in next update

[SWV]

Ok thanks.

I use in play/suspended to record the result
I use in play/closed to move to the next market

[alrodopial]

you can add the new if to your code and then record AND move to next race (without waiting for the Closed signal