Okay. We're continuing on with a couple more examples, I've got three more examples here. Create a VBA Sub that will square cell 2,2 of a current selection. So, when you read that, you should think Selection.Cells 2,2, and place it in cell A1. So, we're going to square that variable. I'm going to input that as a variable x, then we're going to say y equals x squared, and then we're gonna place y into cell A1. First step is to dim our two variables, x and y in my case, you could use a and b or whatever you want. Then, we obtain x as Selection.Cells 2,2. In order for this to work, I need to have a selection though. We then square x to define our variable y. Actually, the goal is to place the result in cell A1. So, I'm just going to shift this down, so we're not covering up A1, and finally, we now take y and we put it into range A1. We can run this using F5, and we take the 2,2 position of the selection, which is five, we square it and place it into cell A1. Example four. Create a VBA Sub that will display the rows and columns of a selection and display in a message box. So, the first step is to dim two variables as integers, the number of rows and the number of columns. Then, we count the number of rows and the number of columns of our selection, and I need to make sure that I have a selection, and then we output that in message box. Your selection has space, nr, number rows, space, rows and space end quotation, and number columns, columns. So, when I run this now, I'll do line by line, we count the number of rows, four, count the number of columns, three, and then we output that in a nice message box. Your selection has four rows and three columns. Finally, Example five. Create a VBA Sub that asks the user for a number with an input box, then adds that number to the current active cell and places the result in a cell that is two cells right and two cells down from the current active cell. So, I'm going to obtain the input box number, that's going to be x, the number in the current active cell is going to be y, and then I'm going to create a third variable z that's going to add x and y, and that's going to be placed into an offset of the current active cell two cells right and two cells down. So, two rows down, two columns over. The first step is to dim x, y, and z. The next step is to obtain x using an input box, y will just be obtained from the active cell, and I'm going to just change this up a little, put a six here as the active cell. So, that's the active cell, z is just x plus y, and finally, we say the ActiveCell.Offset 2,2. So, two rows down, two columns over, that should be D8, will be equal to z. So, let's go ahead and make sure that this works. I'm going to step through this, let's add a number seven, so that it obtained x as seven. We run the next line that's the active cell value y is six, and then we create z which is just the sum of those two, and finally we put that into the ActiveCell.Offset two rows and two columns which would be in cell C8. Now, some of you might be wondering or might be thinking that it's a lot easier, you can consolidate this into just, you could remove these two lines of code, and in fact, you can't do that. So, let me remove y and z from being dimmed, and I can just consolidate this active cell. Instead of z, I can say active cell plus x, all right? I can delete these, and now, I only have a couple rows fewer, and this works exactly the same. I can add eight plus six into the ActiveCell.Offset there. However, while you're learning VBA, I would advise against doing this, it's better to have more variables because down in the locals window, you can see more of what's going on. Here, you only have one variable, so you can't really tell, if you're making a mistake, you can't tell where it is. So, why you're learning VBA, the more variables is fine, more lines of code is just fine, and then maybe later on when you get more comfortable, you can start consolidating lines of code. All right. That's it for this second set of examples. Thanks for watching.