Posted: Sun May 20, 2012 8:12 am Post subject: Q2 -1 triggering some problems, one event jump over ..
Joined: 02 Oct 2008 Posts: 19
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?
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum