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...
by Nate Moore | Mar 31, 2014 | Macros and VBA
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...
by Nate Moore | Mar 24, 2014 | Macros and VBA
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...
