Multiple bets placed all at once cause ERROR code in Bet Ref

[osknows]

The worksheet change event fires when the worksheet changes and the cell/ranges that have changed are picked up in the 'Target' range object.

BA updates excel with 2 different refreshes, one for prices and one for balance updates etc

For price updates 16 columns are updated (cols A:P); therefore 'If Target.Columns.Count <> 16 Then Exit Sub' essentially checks if BA has refreshed prices rather than you just changing the odd cell. If BA has refreshed then Target.Columns.Count =16 and the code below runs otherwise it exits the VBA Subroutine

you can use either...

If Target.Columns.Count <> 16 Then Exit Sub

or

If Target.Columns.Count = 16 Then
'run code
End If

[xraymitch]

If Target.Columns.Count <> 16 Then Exit Sub

My previous post wasn't a request, rather it was a thank you as I had come across your explanation earlier. Should have made myself clearer.



Cheers though,

[osknows]

Sorry, I should have read it properly

Os