by Nate Moore | Apr 28, 2014 | Macros and VBA
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...
by Nate Moore | Apr 21, 2014 | Macros and VBA
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...
by Nate Moore | Apr 14, 2014 | Macros and VBA
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...
by Nate Moore | Apr 7, 2014 | Macros and VBA
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...
