Excel® 2013 On Demand

Controlling a Macro

If a macro doesn’t work exactly the way you want it to, you can fix the problem using Microsoft Visual Basic for Applications (VBA). VBA allows you to debug, or repair, an existing macro so that you change only the actions that aren’t working correctly. All macros for a particular workbook are stored in a macro module, a collection of Visual Basic programming codes that you can copy to other workbook files. You can view and edit your Visual Basic modules using the Visual Basic editor. By learning Visual Basic you can greatly increase the scope and power of your programs.

Debug a Macro Using Step Mode

Click the Developer or ...