by Nate Moore | Aug 11, 2014 | Macros and VBA
There’s a way to programmatically define a range of cells to work with in Excel Video 422. I’m introducing loops, a way to repeat code a set number of times, in Excel Video 422. I’m also adding a few new functions as well, so I hope this isn’t too much for one video....
by Nate Moore | Aug 4, 2014 | Macros and VBA
Tables are a great way to manage Excel data. Excel Video 421 shows how to reference and change a Table using VBA. As we continue our discussion about how to reference data using VBA, it’s worth a few minutes to understand how to work with Tables. If you aren’t...
by Nate Moore | Jul 28, 2014 | Macros and VBA
There are three very useful shortcuts in Excel Video 420. I’ll show you how to quickly comment and uncomment lines of code. For those of you who don’t write a lot of code, by comment I mean to have VBA skip over the line without running the code. You can use comments...
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...
