G
Guest
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 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.