Posted to microsoft.public.excel.misc

peyman

external usenet poster

Posts: 189

macro question

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro Question	Diana	Excel Discussion (Misc queries)	1	July 15th 06 12:28 AM
question on macro	Harry	Excel Discussion (Misc queries)	8	April 13th 06 04:25 PM
Macro question	Terry Bennett	Excel Worksheet Functions	9	January 22nd 06 10:39 PM
Macro Question	carl	Excel Worksheet Functions	1	August 3rd 05 07:56 PM
Question about macro	Jason	Excel Discussion (Misc queries)	0	April 27th 05 10:37 PM

All times are GMT +1. The time now is 02:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us