by Nate Moore | Jul 21, 2014 | Macros and VBA
If you’d like to use a macro in one spreadsheet to change another spreadsheet, watch Excel Video 419. Today we’ll review the syntax to reference another workbook from VBA. The first thing you’ll notice is that the second workbook has to be open for the VBA code to...
by Nate Moore | Jul 14, 2014 | Macros and VBA
In Excel Video 418 we’ll identify ranges on another worksheet in the same workbook. Everything in Excel Video 417 assumed we wanted to select ranges in the worksheet we were in when we ran the code, which is called the active worksheet. By referencing the worksheets...
by Nate Moore | Jul 7, 2014 | Macros and VBA
Excel Video 417 starts our discussion on identifying ranges for our VBA code to work on. In the Macro Recorder videos we were very concerned about which cell we started recording in. Once we can identify ranges of cells, it’s not as important which cell we’re in when...
by Nate Moore | Jun 30, 2014 | Macros and VBA
Excel Video 416 showcases another way to track values in your code and watch when they change. The Watch Window takes a little setup, but once you add watches, you can watch variables, values, and other aspects of your code throughout the macro. As the macro changes...
by Nate Moore | Jun 23, 2014 | Macros and VBA
Excel Video 415 introduces the Immediate Window, one way to keep track of how locations and values in your spreadsheet change as your macro or VBA code runs. Watch for two ways to open the Immediate Window, two commands to get information in the Immediate Window, and...