New Posts For Thread: Gruss Excel Vba Help Plshttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-plsI'm struggling to write some excel vba code that will link to gruss/Betting Assistant. There forum is like tumbleweed so i am hoping someone on here can help pls The code is :Private Sub Worksheet_Change(ByVal Target As Range) If Range("S1").ValueDon't know vba but I'm guessing your problem is that the quick pick list is dynamic (ie, as a race is run, that will disappear from the list).If you have selected the race in position 3, then you want to go to 4 (which is the 'next' race) but a racehttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546248927#546248927Don't know vba but I'm guessing your problem is that the quick pick list is dynamic (ie, as a race is run, that will disappear from the list).If you have selected the race in position 3, then you want to go to 4 (which is the 'next' race) but a raceThu, 17 Sep 2015 09:37:34 -0500Ask Gary and Mark. They are the good guys in this business and don't treat it as a Monday to Friday, 9-5 business, unlike others I could name.Gary wrote an entire programme for me, and said he didn't mind, as it was good practice for him.How generoushttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546246259#546246259Ask Gary and Mark. They are the good guys in this business and don't treat it as a Monday to Friday, 9-5 business, unlike others I could name.Gary wrote an entire programme for me, and said he didn't mind, as it was good practice for him.How generousThu, 17 Sep 2015 02:45:22 -0500I'm fully aware of the manual way of doing things mate but I'm trying to automate things hence the need for the vba code.https://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546246123#546246123I'm fully aware of the manual way of doing things mate but I'm trying to automate things hence the need for the vba code.Thu, 17 Sep 2015 01:50:19 -0500I tend to use the auto select markets function on the markets tab and then set it to the time I want the market to change usually between 1 and 5 minutes before the off, nhttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546245449#546245449I tend to use the auto select markets function on the markets tab and then set it to the time I want the market to change usually between 1 and 5 minutes before the off, nWed, 16 Sep 2015 22:27:12 -0500Smar Tarse 16 Sep 15 21:00 Joined: 01 Feb 07 | Topic/replies: 5,468 | Blogger: Smar Tarse's blogWhat do you do with the value 2 in "Q2" ? Should it .Value = 0 for false ??value 2 controls the refresh rate of Betting Assistant after then -1 trigger hhttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546242113#546242113Smar Tarse 16 Sep 15 21:00 Joined: 01 Feb 07 | Topic/replies: 5,468 | Blogger: Smar Tarse's blogWhat do you do with the value 2 in "Q2" ? Should it .Value = 0 for false ??value 2 controls the refresh rate of Betting Assistant after then -1 trigger hWed, 16 Sep 2015 15:21:00 -0500What do you do with the value 2 in "Q2" ? Should it .Value = 0 for false ??https://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546241713#546241713What do you do with the value 2 in "Q2" ? Should it .Value = 0 for false ??Wed, 16 Sep 2015 15:00:57 -0500I'm trying to write some excel vba code for gruss/betting assistant so that the next race will be selected when all my bets are matched. So far i have come up with the following but some reason it jumps/misses races in the quick pick list.When all myhttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546241519#546241519I'm trying to write some excel vba code for gruss/betting assistant so that the next race will be selected when all my bets are matched. So far i have come up with the following but some reason it jumps/misses races in the quick pick list.When all myWed, 16 Sep 2015 14:45:20 -0500Forgive me for asking but what is it your trying to do is it auto load the quick pick list?https://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546241141#546241141Forgive me for asking but what is it your trying to do is it auto load the quick pick list?Wed, 16 Sep 2015 14:20:42 -0500Ok ive tweaked this and come up with the following that seems to work but misses some races from the quick pick list!Private Sub Worksheet_Change(ByVal Target As Range) If Target.Columns.Count = 16 Then Application.EnableEvents = FalseIf Rhttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546240609#546240609Ok ive tweaked this and come up with the following that seems to work but misses some races from the quick pick list!Private Sub Worksheet_Change(ByVal Target As Range) If Target.Columns.Count = 16 Then Application.EnableEvents = FalseIf RWed, 16 Sep 2015 13:46:12 -0500I'm struggling to write some excel vba code that will link to gruss/Betting Assistant. There forum is like tumbleweed so i am hoping someone on here can help pls The code is :Private Sub Worksheet_Change(ByVal Target As Range) If Range("S1").Valuehttps://community.betfair.com/chit_chat/go/thread/view/94038/30587299/gruss-excel-vba-help-pls?post_id=546240373#546240373I'm struggling to write some excel vba code that will link to gruss/Betting Assistant. There forum is like tumbleweed so i am hoping someone on here can help pls The code is :Private Sub Worksheet_Change(ByVal Target As Range) If Range("S1").ValueWed, 16 Sep 2015 13:27:21 -0500