Refresh display of Range when ScreenUpdating is False

excelrangerefreshvba

Is there a way to refresh the display of only a specified range of cells from VBA, when ScreenUpdating = False?

What I mean is the following:

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

Range("A1").Calculate
Range("A1").SomeFunctionThatRefreshesThis

Karl

Best Answer

If ScreenUpdating is set to false then the update will not be shown until ScreenUpdating is set to True. The only way that you can make this act the way you want is to use the ScreenUpdating property in a more fine grained way. For example:

Application.Calculation = xlCalculationManual

Range("A1").Calculate
Application.ScreenUpdating = False
Range("A1").SomeFunctionThatRefreshesThis
Application.ScreenUpdating = True
Application.ScreenUpdating = False
...
Related Topic