confusion123
Active Member
- Joined
- Jul 27, 2014
- Messages
- 400
The code below is in a worksheet.
When I put in a breakpoint as shown, why is ScreenUpdating set to TRUE, when I specifically set it to False?
When I put in a breakpoint as shown, why is ScreenUpdating set to TRUE, when I specifically set it to False?
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Dim a As Integer
a = 10 'BREAKPOINT SHOWS Application.ScreenUpdating = TRUE!!!
Application.ScreenUpdating = True
End Sub