In this video, we're going to start writing our first macro. And also we will get to know the range object in Excel. So the range object in Excel is basically an object that allows us to deal with cells in Excel VBA. And to start writing our first macro, we need to first of all go to the developer tab on the ribbon here and click on Visual Basic, and that's to open the Visual Basic environment. Now to write a macro, we need to insert a module First of all, so to insert a new module, we could go to this insert module tool here, click on this arrow and then click on module. Okay, we can also go to the Insert tab on the ribbon and click on module.

Okay, so that's another way to do it. Okay, so now I'm going to start writing my first macro. So to do that to start writing a macro First of all, I need to give it a name. So I need To write the word sub, and then write the macros name. And the macros name should not include any spaces and it cannot contain dashes as well it can contain underscores so you can separate words with underscores, but I'm just gonna name it first macro, okay. And then when I press enter, I press Enter several times just to give myself some space and when I press enter, Excel VBA will insert the end sub statement, which marks the end of my macro at this end sub statement is going to be inserted automatically.

Now the macros name cannot contain some certain words that are reserved in Excel VBA. I'll include a PDF in the resources section about these words for you. Okay, so basically the sub statement and the name of the macro marks the start of my macro or Sub procedure and the end sub marks the end of my Sub procedure or macro. And between the sub and the end sub statements, I'm going to write more instructions, I'm going to write some lines of code that Excel VBA will perform step by step from top to bottom. So VBA we'll go through these instructions from top to bottom and execute them that way. Okay, so this is how instructions are executed in Excel VBA.

They are instructions executed from top to bottom, of course, you can move around in the macro by writing some special lines that we will learn about later on in the course. Okay, so let's start dealing with the range object. So first of all, we're going to learn how to change the value of a single cell. Okay, and I'm going to have the Visual Basic environment open here and you're going to be able to see parts of the Excel grid here in the background because we're going to perform actions here with the VBA involved. And you're going to be able to see the results of these actions in the background. Okay?

Okay, so to change the value of a single cell, you can right range, then open brackets and then open double quotes and then you put the reference for the cell, I'm going to change the value of sell a one, okay? And then close double quotes, and then I'm gonna close parenthesis here, and then equals 15, for example, okay, so I'm going to put the value of 15 in sell a one. Okay, so in order to run the macro, we need to either click on this button here at the top, which is the Run button, or you can also hit f5 on your keyboard. So I'm going to click on this button here. And as you can see here, the value of 15 has been inserted into cell A one OK, so if I need to affect actually a range of cells, not just a single cell, and this is actually for a contiguous range of cells, we're going to actually put a colon after the reference for the first cell, and then put the reference of the ending cell.

Okay, so I'm going to affect, for example, a one to F 10. For example, I'm going to put the value of 15 in range a one to F 10. And this is actually how you can select a range of cells in Excel as well. So in Excel, if you right here, a one two f done, okay, you're going to be able to select the whole range a one to F 10. Okay. So if we execute this line of code here, if I press on the run button here, the cells a one two f 10 are going to be getting the value of 50 Okay, so to start writing another line of code, you can just press Enter on your keyboard, I'm going to press ENTER again, because I like to have more than one line actually separating my lines of code, because this makes the readability easier for me.

But actually, any space that you put between the lines of code will not affect your macro at all. It will not affect the speed or execution at all. Okay? And I'm going to start writing, for example, another line of code here, so range, and then I'm going to open parentheses, open double quotes, for example, g nine, and then closed double quotes, close parenthesis equals 150. Okay, and as you can see here, even though I typed the word range in, all in uppercase, Excel actually corrected it and it's made only the first letter is uppercase, and the rest of the The letters are lowercase. And even though also I have typed the G nine, the G and lowercase this will not affect the execution of the code.

Okay? So Excel will still understand that this is cell g nine. So I'm going to delete the values in these cells here. And I'm going to execute the code again here. So if I execute this code, you can see here that all the cells from a one to F 10 have acquired the value of 15. And cell g nine has acquired the value of 150.

Okay, now of course, as we stated earlier, Excel has executed these lines of code step by step, Okay, so the first line here, a one to F 10 equals 15 has been executed first and then the line g nine equals to 150. has been executed second, or afterwards and of course, you do not notice that Because they're both executed in a flash, okay, but just know that they are executed step by step, okay, they have not been executed together, actually, this line of code has been executed first and then this line of code. Okay, so we've seen how to affect the value of a single cell. And also we've seen how to affect the value of a contiguous range of cells, we're going to see as well now how to affect the value of non contiguous cells. Okay, so I'm going to delete these lines of code.

I'm going to delete this as well here on my Excel grid, and I'm gonna start affecting a range of non contiguous cells. That means that the cells are not beside each other. Okay? So I'm going to write range, and then open parentheses, open double quotes, and then maybe a one and then comma Then f then okay and then close double quotes close parenthesis equals 1000. Okay. So this actually will put the value of 1000 in cells a one and F 10, but only in these two cells, not this cells between them.

So if I run this code here, for press on my run button, you can see here on cell A one and cell f 10, only, only these two cells, the value of 1000 has been put in these two cells only and actually the cells between them are still blank. So this is how you can affect the values of non contiguous cells. Okay, so I want to show you as well that you can actually mix between a range of contiguous cells and a single cell in one range objects statement here, so you can write actually range, a one to F done and then a comma and then F 15 equals 1000. And what's gonna happen here, when we run this statement is that cells a one to F 10 are going to acquire the value of 1000. and sell f 15 as well is going to acquire the value of 1000.

So I'm going to delete here are the values on my Excel grid here. And I'm going to go back to my Visual Basic environment. And when I click on the Play button here, watch what's going to happen. Here you can see your cells a one to F 10 have acquired a value of 1000 and cell f 15, as well has acquired the value of 1000. Okay, and this is equivalent to actually writing that on two statements. Okay, so we can write range a one to F to n equals 1000.

And then range f 15 is equal to 1000. So if we delete that, and then run the code again We're going to get the same result. Okay, so if you run that, we're going to actually get the same result here. Okay guys. So in this lecture, we've written our first macro and we've had an introduction to the range object in the upcoming lectures. We're going to dive deeper into the range object and we're going to learn a lot more about it.

So thanks guys for watching this video and I'll see on the next one