Application Updating?
 

Could there be an instance when it would be necessary to leave the
application updating on when running code. For example if the code relies on
a reference cell that is changed in an earlier part of the code. Do all the
changes to cells take place even though they are not being refreshed on the
screen. The code I am refering to is...

'Turn off application updating
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

Thanks, sorry this wasn't written very clear.

Application Updating?
 

Sure there are many, one example is if the code changed a cell value
and then needed to refer to that cell later in the code to manipulate
another cell.

Sandy



Bythsx-Addagio wrote:
Could there be an instance when it would be necessary to leave the
application updating on when running code. For example if the code relies on
a reference cell that is changed in an earlier part of the code. Do all the
changes to cells take place even though they are not being refreshed on the
screen. The code I am refering to is...

'Turn off application updating
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

Thanks, sorry this wasn't written very clear.