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: