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