Q2 trigger

[keesbart]

Hi,
I have a problem with moving to the next market by using the Q2 trigger.

I want to move to the next market if the start of the race did not happen after e.g. 5 minutes after the scheduled off time.
In cell AB2 I have put in -0:05:00.
I use also D2 (the time is negative after scheduled off).
In the program I have the following statement
IF RANGE ("D2") < RANGE("AB2") THEN RANGE ("Q2") = -1

What happens is that the program does not move 1 but 2 markets.

Can somebody tell me what I am doing wrong?

[GaryRussell]

Range("Q2")=-1 generates another worksheet_change event which causes your code to run twice. Disable events to prevent this. It's also best to only run your code during one particular change event and that is when the prices are updating. 16 columns are updated when the prices are updated so your code should be as follows.

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.Columns.Count = 16 then
   Application.EnableEvents = false
   ' your code goes here
   Application.EnableEvents = true
End If

[keesbart]

Gary thanks for your quick response.
I will change the program as you suggested.