Clear range when next market selected

[vrupper]

Hi all,

I'm learning VBA as I go along, and have started with the AutoReloadQuickpickList template, added some of the Place_Bets_Multi_Same_Selection formulas to get a sheet that I can paste all my selections into in the morning and allow BA to cycle through the Win markets for the day and place my bets.

One of my criteria is if the odds are drifting. I have a bit of code that copies the lay odds if the timer in S1 gets to 900 seconds from the off into range AG5:AG55.

Obviously for the next market I need this range to be cleared, how do I trigger the code below when the market changes?

Code: Select all

Worksheets("Sheet1").Range("AG5:AG50").Clear

[vrupper]

All sorted with a bit of testing.

I added to my copy and paste code to clear contents if the time left before the off was greater than 15mins and put a counta formula on the column so that once they are cleared it stops the process running continuously.

Thanks