Question about Global Status Excel

[TheNagsHead]

I am trying to place a Back bet when the SP is greater than 3.(Plan is to place trade when SP in certain range but trying to keep it simpler to begin with) I have added the Actual SP price in column AF and written some very basic code to place a Back bet if SP is greater than 3, problem now is when the market gets suspended just before the OFF and market suspended is in the Global Status column the order doesnt get placed until i deleted the market suspended text. Anyone know how to get around the problem of having the order executed without having to manually delete the Market Suspended text.