I have created the first draft of the template which I am about to share in a new thread so it's easy for the wandering lurker of this forum to find.
I tried simplifying the code to something like above but for some reason it wouldn’t recognise it so for now, I just wanted to get the spreadsheet out for other members to enjoy and test, I have made quite a lengthy bit of code for the template. The bottom line is that it works and should generally run pretty darn fast so i'm happy to share now and take your advice on board to improve things in my own time.Case "B"
Call BackOne
Worksheets("Bet Angel").Range("J32").Value = "C"
Case "C"
etc etc.......
One more question…
When closing a trade what is the difference between L9 = “LAY” stake = £2 and L9 = “Close_Trade” and stake = £2? When would you ever use the individual command option Close_Trade over just laying?
Callum