what is this macro command doing ?

[brecki]

Hi Gary,

you sent me a macro code earlier and I just want to understand one thing.

What is this macro doing, especially what is the meaning of the line


If Target.Columns.Count = 16 Then


?????????

Why is it exactly 16? When I change the number 16 to anything else, the macro seems not to work anymore, is that correct? I tried to find it out but didn´t find a logical explaination.


The complete macro code was:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Columns.Count = 16 Then
Application.EnableEvents = False
calcGreenUp
Application.EnableEvents = True
End If
End Sub


Thx for helping. Regards Stefan

[GaryRussell]

When Betting Assistant writes data to Excel it does it in ranges of cells. When it writes the odds the range includes columns A to P which is 16 columns. This is the best place to put your logic because when the column count is 16 it has just updated the odds.