VBA for Excel Home Page

 

VBA for Excel Introduction

 

Program by Levels

 

VBA for Excel Beginners Level

 

VBA for Excel intermediate Level

 

VBA for Excel Advanced Level

 

 

 

Tutorial on VBA for Excel (Macros)

bringing you the simplest and most efficient ways
to do things in VBA for Excel

Application.ScreenUpdating = False

Extracted from:
VBA Lesson 2-3: VBA for Excel for the Application
Levels: Intermediate and Advanced)

Application
 Application is a VBA object, IT IS EXCEL.

ScreenUpdating
When you don't want to see your screen follow the actions of your VBA procedure, you start and end your code with the following sentences:
Application.ScreenUpdating = False
Application.ScreenUpdating = True

There are 10 other useful methods that apply to Application including Quit.........

33 complete lessons and 25 Excel spreadsheets in
Tutorial on VBA for Excel (Macros)
VBA for Excel made simple
'                
       

 

Developed and Presented by PLI Consultant Inc