Macro and formulas

[alrodopial]

Garry or anyone else, what Excel execute first (after an odds update - 16 columns):

The formulas that are connected to lets say prices in column F (back odds 1) and then
the VBA code (If Target.Columns.Count = 16 Then ...)

or the other way?


Garry can you post the steps that BA follows when it reacts with excel?
e.g first it reads the columns for bets and send if any then updates the bet reffs (columns 4 (?)) then updates the odds (columns 16) ... then reads the cell q2 etc.
It would be very useful for further VBA coding.
Thanks

[GaryRussell]

I've been meaning for some time to add something to the FAQ. I'll add something shortly.

You are correct in saying the formulas are calculated before the worksheet change event is fired.