mellenec wrote:I have this code running in my Excel sheet
Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count <> 16 Then Exit Sub
Application.EnableEvents = False
' CODE placing bets
Application.EnableEvents = True
end sub
What makes that when the Trigger betting is enabled , I cannot enter my code,
because the columns count remains <> 16?
It's quite by chance that I lighted on the Castillo thread
Excel freezes when trigger betting is enabled
where he exposes the same problem as mine,
that is :
I was using the P2 & Q2 cells for storing some of my constants, which erased the refresh rate updated by BA.
How many people know these cells should not be used for one's own data?