Clear & Cols V & W

[excelhasey]

Hi all, its been a while since a had a stab at a few scenarios and my memory is fading a little - If I use the Clear bet does the values stored in Cols V (Ave Matched Odds) & W (Matched Stake) also disappear ??

If so how best am I to place a bet then clear the trigger ready for another bet but I want to use the (Ave Matched Odds) & (Matched Stake) in part of my formula for deciding what type of bet and how much to stake etc

Any thoughts / advice ??

[Captain Sensible]

You could take a snapshot with VBA before entering the clear command or use the MyBets sheets and Vlookup etc if you preferred formulas