14 VBA Advanced (Speed Up Macro) (Be Specific where to Run Macro)

14 VBA Advanced

Follow-up of VBA Beyond Basics and VBA for EveryOne Series

Topics in this Video:
Speed Up Running of Macros
Be Specific !!! - Your Macro should know in which workbook or sheet it should RUN

Code:
Application.ScreenUpdating = False
Application.StatusBar = "Hello World"
Range(“A1:A10000”).Value = Range(“B1:B10000”).value
ThisWorkBook.Activate
Sheets(“Sheet1”).Select
Sheets(1).Select

[tonio]

What if you are running a macro they calls multiple macros. Do you turn it off and on within each individual macro or just add it to the master macro that calls the other macros?