Trigger

[dixiedean]

Hi can anyone help before i go insane!
I am a novice at vba and what i am looking for is to copy the lay prices from column f and paste them only once into column bb when the race goes in play and then to clear them when the market changes.

I have got some of it to work but then the other part wont,

Pleas help

Dixie

[dixiedean]

Edit : The lay prices from column H i meant

[dixiedean]

Ok i have got the first bit to work using some code i found on the forum but how do i edit it to clear the cell "W2" when the market changes?

Code: Select all

    Private Sub Worksheet_Change(ByVal Target As Range)

        If Target.Columns.Count <> 16 Then Exit Sub

    If Cells(2, 22) = 1 And Cells(2, 23) <> 1 Then
       
    Application.EnableEvents = False
    Application.Calculation = xlCalculationManual

    Range("bb5:bb25").Value = Range("h5:h25").Value
    Cells(2, 23) = 1

    Application.EnableEvents = True
    Application.Calculation = xlCalculationAutomatic
    End If
 



    End Sub

Thanks