Open a brand new Excel Instance, I'm using 2007 and 2010
Paste this into the Sheet1 Code view in the VB editor
Sub Test()
Excel.Application.ScreenUpdating = False
MsgBox Excel.Application.ScreenUpdating
End Sub
Add a watch of the Excel.Application.ScreenUpdating variable should initially be TRUE
Put a break point on the MsgBox line and run it.
The code stops on the msgbox line.
The variable in the watch windows is set to false, if I hovver my mouse over the Excel.Application.screenUpdating variable it says TRUE!!!
If I then f5 to allow it to continue running then the msgbox says FALSE.
any ideas anyone?
Paste this into the Sheet1 Code view in the VB editor
Sub Test()
Excel.Application.ScreenUpdating = False
MsgBox Excel.Application.ScreenUpdating
End Sub
Add a watch of the Excel.Application.ScreenUpdating variable should initially be TRUE
Put a break point on the MsgBox line and run it.
The code stops on the msgbox line.
The variable in the watch windows is set to false, if I hovver my mouse over the Excel.Application.screenUpdating variable it says TRUE!!!
If I then f5 to allow it to continue running then the msgbox says FALSE.
any ideas anyone?
Comment