Abulafia
Board Regular
- Joined
- Jun 15, 2004
- Messages
- 66
I have the following code:
I would expect this to clear the two columns without showing me it happen but, when I run the code, I have to watch as the screen changes cell by cell to empty values.
Why is the ScreenUpdating property not working in this instance?
Code:
Application.ScreenUpdating = False
Range(nrColumn1).ClearContents
Range(nrColumn2).ClearContents
Application.ScreenUpdating = True
I would expect this to clear the two columns without showing me it happen but, when I run the code, I have to watch as the screen changes cell by cell to empty values.
Why is the ScreenUpdating property not working in this instance?