Macro optimizing

[Joseph Assaf]

How can i stop all the graphical displays while im
activating a Macro to speed up the work, especially when
it consist of transporting data through multiple workbooks?

 

[David McRitchie]

Hi Joseph,
Turn off screen updating and calculation within the macro, and
turn back on when finished.

See the following two web pages.

Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

Slow Response and Memory Problems
http://www.mvps.org/dmcritchie/excel/slowresp.htm