C screenupdating word
For example, if you have three worksheets ("Sheet1", "Sheet2", and "Sheet3") in a workbook ("My Workbook"), you can reference "Sheet2" with either Whenever you can, declare values as constants, rather than variables.
Since their values never change, they are evaluated only once when your code is compiled, rather than each time they are used at run time.
By doing so, a great deal of overhead is done at compile time ("Early Binding") rather than at run time ("Late Binding").
Worksheets(1) 'Find last cell with data in column A. You can increase the speed of some procedures by keeping screen updating turned off.