macro question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
what is the pupose of having the following two lines at the beginning
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

and the following two lines at the end of the Codes for VB?

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
thanx
 
It speed up the running of the macro because it does not have to wait for
the cell values to be calculated of the screen changed as the macro makes
changes.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
thanx Sandy.


Sandy Mann said:
It speed up the running of the macro because it does not have to wait for
the cell values to be calculated of the screen changed as the macro makes
changes.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Back
Top