VBA code will operate at the speed your computer will allow, which is still significantly faster than you can operate. Since VBA code can do the same things as we could with the mouse or keyboard, why bother to use VBA at all? For example, in Excel, you can create a chart you can also create a chart using VBA, it is just another method of achieving the same thing. Most things which you can do with the mouse or keyboard in the Microsoft Office suite, you can also do using VBA. Visual Basic for Applications (VBA) is the programming language created by Microsoft to control parts of their applications. Apply single accounting underline to selection PART ONE: How to use VBA Macros What is VBA?.Fix the range of cells which can be scrolled.Turn off auto fit columns on all Pivot Tables.Resize all charts to same as active chart.
