All of the debugging tools we’ve discussed so far assume that you’re running sequentially through a macro, from beginning to end. In Excel Video 414 I’ll show you 3 ways to change which line of code runs next. You can skip ahead in a macro, back up and rerun code, or...

Excel Video 413 has two more tricks to add to your debugging arsenal. Both tricks relate to how to respond to a macro within a macro. Macros can call (or run) other macros. We’ll call the macro that calls another macro the parent macro. We’ll call the macro that is...

Breakpoints, the topic of Excel Video 412, make your code stop running exactly where you need to analyze your code. If you have a really long macro or code with a lot of loops, breakpoints can save you a lot of time stepping through your code. Watch today to learn how...

Writing macros and code is great, but when you need to debug problems in your code, start by watching Excel Video 411. The challenge with finding problems in your macros and code is that they generally run so fast it’s hard to tell where the problems are. By choosing...

Excel Video 410 gives you a behind the scenes look at what the Macro Recorder is doing in Visual Basic for Applications when it records a macro. Watch how I use Alt+F11 to open the Visual Basic Editor and follow along as I record a macro in Excel. If you want to learn...

Looking for a Moore creative way to launch macros? Watch Excel Video 409 to learn how to attach macros to shapes and pictures in a spreadsheet. The trick is to design and format the shape or picture you want to launch the macro and then right-click. Choose Assign...

Excel Video 408 shows you how to create a button to run a macro on your spreadsheet. Excel Video 407 added buttons to the Ribbon and the Quick Access Toolbar, but if you only want the macro to run on one spreadsheet, you may prefer to simply have a button to run the...

Excel Video 407 will make your macros easier to access. While you may occasionally write a one-time macro to solve a messy problem on a complex spreadsheet, many of the macros you write will be tasks you want to repeat over and over again. We’ve already talked about...

Excel Video 406 is a brief introduction to the Visual Basics for Applications code created by the Macro Recorder. Alt+F11 is the keyboard shortcut to get to the VBA screen. We’ll see where Excel stores the code generated by the Macro Recorder and get a 30,000 foot...

Watch three tricks to help the Macro Recorder do a better job in Excel Video 405. The first trick is to switch between the absolute and relative references we discussed in Excel Video 404. Watch how I start with an absolute reference to cell A1 so that no matter where...

There are two ways to record a macro in Excel Video 404. Absolute reference is the default. An absolute reference always goes to the same cells to perform the macro. A relative reference records the macro in relation to the cell you’re in. If the macro goes three...

Excel’s Macro Recorder is a great place to start learning about macros, and we’ll do that in Excel Video 403. Watch how to start recording a macro from the Developer tab we added in Excel Video 402. You’ll see how to name the macro (make sure there are no spaces) and...

We’re starting a new topic in Excel Video 402, macros and Visual Basic for Applications (VBA). Macros and VBA are helpful ways to automate repeating processes in Excel. Given how much data is in the cloud lately and how much cleanup is required to work with some of...