Gruss Forum

jossari · Posted: Sun May 20, 2012 8:51 am Post subject:

Hi,

I am using following code to jump next event:
- if market is closed (CELL F2) or if cell value AS18 = 1 (= "my own calculated cell in certain criterias")

The Cell value AS18 will check some other items from next event and if they are TRUE cell AS18 value will be 1 and then I will want to jump next event.

The problem is now, that this code will jump to next race too fast. I mean althoung next event and its cell value AS18 = 0, this code will jump over this event to the next event. This mean that one event will be missed ..

Is there any possibilities, that program will wait so long that cell value AS18 is certainly updated before program will jump out from if-loop?

BR: AH

If Target.Columns.Count = 16 Then
Application.EnableEvents = False

If Range("A1").Value <> NYKYMARKKINA Then marketMUUTTUNUT = False
If Range("F2").Value = "Closed" Or Range("AS18").Value = 1 Then
If Not marketMUUTTUNUT Then

Range("Q2").Value = -1
marketMUUTTUNUT = True

End If

.....