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


Replace @mailinator.com with @tiscali.co.uk


"peyman" wrote in message
...
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

thanx Sandy.


"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"peyman" wrote in message
...
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