way excel updates data

[alrodopial]

Hi,
I just realized something that really don't like.
Gary correct me if I'm wrong.

Data in excel:
In every circle first step is to update columns A to P (16 columns)(mostly odds and amounts) and then in second step columns T to X (5 columns)( bet reff,bet time,matched odds and amount,p/l) and this happens again every lets 5secs (refresh rate)

In my code I have the usual (as everybody else I think):
If Target.Columns.Count = 16 Then
my macros here

So if I have a trigger (fired by a macro) that depends ie on bet reff ( ie a previously placed bet that I want to check if and how much it was matched so I can place another bet now), when my trigger (and bet of course) will be placed?
With my current code (everybody's code) it will NOT be placed at the time that odds are updated(16 columns) in the current update but in the next update (after 5secs).This is because my code is running (checking conditions) when the 16columns are updated(first step of the update) but at this point the bet reff has not been updated yet.
If I'm right I will have to change the macros that depend on columns T to X
Gary?

[alrodopial]

Gary your thoughts?

[GaryRussell]

Bets can only be triggered once on each refresh because the triggers are only read once. The trigger column is read immediately after the 16 columns are updated so even if you populated the trigger column before the next refresh it would not fire.

[alrodopial]

Bets can only be triggered once on each refresh because the triggers are only read once. The trigger column is read immediately after the 16 columns are updated so even if you populated the trigger column before the next refresh it would not fire.

Now this is something that I REALLY believe is wrong and somehow must be changed/fixed
My logic tells me that I want to place a bet when I have ALL the info available - odds, amounts, reff,matched amounts etc -

I guess you can update at once columns A to X - including the columns Q to S that are used from us (triggers,asked odds,asked amounts) even if they contain formulas, conditional format etc.
This way someone must use the
If Target.Columns.Count = 24 Then
in the code
Or even better you can update any additional columns (sp etc) at once.
Then the ie
If Target.Columns.Count = 25 Then
can be used

To make things not complicated you can add in preff the way BA will update columns.Default can be remain the current.

If I remember correctly cell Q2 is also read at the beginning of every update instead of the end of the update (when all calcs are done)
Thanks