Screen Updating - Unable to Disable Application.ScreenUpdating

vthokienj

Board Regular
Joined
Aug 1, 2011
Messages
103
I am unable to disable the Application.screenUpdating propery. I've seen this issue referenced in various places but have yet to find a solution. Setting this value to false does not seem to do anything, as the value remains true in the watch window. Also, the screen still udpates.

Code:
Application.screenUpdating = False 
Sheets(sheetname).Cells(1, 1) = "textoutput" ' breakpoint here shows Application.screenUpdating still has a true value
a = 10 ' breakpoint here shows that textoutput is visible on screen (yes cell was clear prior to above statement)

Most online references to this property show the s in screen as being capitalized, but Excel 2013 auto-corrects it to be lowercase.

Thanks for any help.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
When you are in debug mode, screenupdating is always true.
 
Upvote 0

Forum statistics

Threads
1,215,064
Messages
6,122,941
Members
449,094
Latest member
teemeren

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top