VBA for Excel Lesson 12: Working with the Application

Application is a VBA object, IT IS EXCEL. For example:
Application.Quit
will close Excel all together.

ScreenUpdating
When you do not want to see your screen follow the actions of your VBA procedure (macro), you start and end your code with the following sentences:
Application.ScreenUpdating = False
Then at the end:
Application.ScreenUpdating = True

CutCopyMode
After each Copy/Paste or Copy/PasteSpecial operation, you should empty the clipboard with the following line of code to make sure that the computer memory does not overload.
ActiveSheet.Paste
Application.CutCopyMode=False

There are   three sections in  this website and in the downloadable tutorial on VBA for Excel.

Section 1: Excel Macros Programming: 10 lessons
This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will learn about  security and discover "events" (an event is what starts  the macro).
Section 2: Excel VBA Vocabulary: 13 lessons
Developing a macro is like talking with  Excel and to do so you need to use a language called VBA. There are over a thousand VBA words but you will really need only 100 to talk with Excel about workbooks, worksheets, cells, databases, loops and to develop simple and powerful macros.
Section 3: Forms and Controls in VBA for Excel: 10 lessons
The form is a small window that allows the user to submit values that will  be used by the  macro. To  these forms you add controls (command buttons, text boxes, list boxes and others).

  *If you have a color printer select Black/White to print this page.