I have another short screencast here that's called the resize property. I have not yet taught this. I may have presented this in one screencast just briefly, but this is really valuable when we do R1C1 style. I'm just going to show you a couple of examples here of where we might want to use the resize property. First, what it does. I'm just in a spreadsheet here. I don't have a starter file for this because it's just so simple, but let's go over to Visual Basic. I'm going to put a test tab in here, and I'm just going to say range A1. That's going to be our starting point, range A1, so cell A1. Then if I do resize, let's just do one row, three columns. What this does is it starts in range A1, and then it outputs into A1 and spilling over to the right or down, it's going to give us a one row, three column array. In that array, I might just do "Hello". So let me show you what happens when we run this. I just press "F5" to run that. What it did was in A1, so that's range A1 but resize an array one by three, it outputs "Hello". It's really valuable because combined with R1C1 style, a lot of times in VBA code, we want to do something to two columns, we might want to sum these. In other words in Excel, we would sum that cell and that cell, and I mean in R1C1 referencing mode here. I can press "Enter", and I drag this down. As I introduced in the R1C1 introductory screencast, when we're using relative referencing, all of these formulas are exactly the same. We have RC negative 2 in square brackets, RC negative 1. Let's go down to the third one here. They're all the same. These formulas are exactly the same. What I'm going to do is I'm going to go up here and I'm going to copy that formula, "Control Copy", press "Enter". I'm going to delete these. What we're going to do is we're going to use cells 3, 4. That's also D3, but I'm going to use cells 3, 4. Then I'm going to use the resize property, and we're going to output that formula that I just copied. That's going to be the result here. Let's change this to range or we're going to use cells row 3, 4 resize. Now, this is four rows, one column, we're going to output it here. Four rows, one column, and I'm going to.formulaR1C1 equals, and I'm going to paste what I copied. Starting in cells 3, 4; row 3, column 4, we're going to output in a four rows, one column array. The formula in R1C1 style is in quotations. You have to put quotations here equals sum of the value that's in the same row, two columns to the left plus same row, one column to the left. When I run this, let me show you. We're starting here with nothing in those cells, and I go ahead and run this. What we've done is we've placed formulas in these four cells, and it's the same exact formula, and it makes it really easy to add two numbers just like we did here. Now, let me show you where it's useful because if you don't know the number of rows that you're summing, so maybe we just did four but maybe you have five or let's actually do six, you can do a couple of things to make this a lot more flexible. The first thing I'm doing is I'm dimming nr, number rows as an integer, counting the number of rows like we've done before. Then what we're going to do is we're going to resize this, not just four, but this is going to be the number of rows. If we have six items, that'll be six by one. If it's four items, it'll be four by one. Now, this adapts to whatever size data we have on our worksheet. Then I can just go ahead and run this, and you see that we do that and let's go ahead and add in a couple of more lines here. You see the autofill kicking in there, but that doesn't usually happen when you run VBA code, so let's just make sure that it works, and we sum those. We're going to be using the resize property with the cell's property, with a lot of the examples we worked through in this module.