Trigger cells cleared when next market selected?

[theclothcat]

Hello everyone,

When using Excel trigger betting and VBA code, does anyone know if the trigger cells (Q5, Q6, etc) are cleared automatically by Betting Assistant after the next race has been selected by putting -1 in Q2?

In other words, do I need to clear the trigger cells myself with code e.g. "Worksheets("Sheet1).Range("Q5").Value = "" before I put -1 in Q2?

Thank you for any help you can give.

[GaryRussell]

They are not cleared automatically because they could contain a formula for creating the trigger which would be erased. So you will have to clear them as suggested.

[GaryRussell]

You could also use Clear on the range.

Code: Select all

Worksheets("Sheet1).Range("Q5:Q50").Clear

[theclothcat]

Thanks Gary. I'll do that.