many markets in first tab - target

[alrodopial]

I have many markets in first tab linked into excel, ie at A1, A10,A30 etc

Does BA updates more than one market at the same refresh? - at some moment -
ie first market and 3rd market, markets A1 and A30 at the same time

If so how can I understand that I must search range A1:P9 AND A30:P39?
what is inside target at this case?
(If Target.Columns.Count = 16 Then)

[alrodopial]

also when a market is closed , ie F2=Closed
does BA updates excel?

[Captain Sensible]

Osknows gave me this code which I found useful to see which cells get updated from BA -

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
 Debug.Print Target.Address
End Sub

It will output which cells are updated in the immediate window of VBA editor, so if you slow down the refresh rates of the sheets (just to see things clearer) you'll see which cell ranges are being updated at each refresh or more likely combination of refreshes from each tab separately.

If you use the above code on a closed market you'll see that the 16 column range A1:P4 market details is still be refreshed but obviously there's no longer any price data being sent. I did put in a request for use to be able to turn on and off the auto refresh via excel as I reckon that'd be useful for cases where markets are closed.