Moving to next market after bet placed

[vanbuuts]

Hi all, I have some code that moves to the next market if there is no bet - as below

But I want to move to the next market when my bet is placed, when I try and do so all the bet refernece from the last market are carried over and therefore no bet is placed on the new market, Please help how I can code this. When I add code to clear the bet reference it keeps placing the same bet on the original market without moving to the next

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
   
    If Target.Columns.Count = 16 Then
        Application.EnableEvents = False
       
       
        If [A1] <> currentMarket Then marketSelected = False
        currentMarket = [A1]
        If [S1] = "Switch" And Not marketSelected Then
            marketSelected = True
                        [Q2] = -1
            Clear
                   
         
      End If
             End If

End SUb

[Captain Sensible]

When you connect BA to the excel sheet do you have the options "Clear bet refs on auto selct market" and manual select market ticked?

[vanbuuts]

Good shout - saves using any VBA