Hey guys, welcome back. So in this video, we're going to discuss the range dot address property. So the range dot address property, what it does is that it outputs the address of a range. And it has actually some arguments, but all these arguments or all these inputs are optional, okay, all of them are optional. So even if you don't enter these inputs, the range dot address property is still going to work because these inputs will get some default values. Okay, so I've created a macro here or a Sub procedure called range underscore address.

And let's have an example. So I'll write range, a one dot address, and actually if we just run that it will still work. But if you open parentheses you will see the arguments or the inputs that you can enter into the range dot address property. And as you can see here, all the inputs they do have brackets around them. And that means that they are optional. So any input that you see that has square brackets around it means that it's optional, you do not have to provide it.

Okay. And if you don't provide any of these inputs, they will got some default values. And you can know the default values that each input gets. If you search this on the Microsoft directory network, you will search for the range dot address property, Google that and you will know it you can actually highlight that and press f1 on your keyboard and this will take you to the page explaining it on the Microsoft directory network. Okay, so as you can see here, this is the range dot address property in Excel and you can see here that there is an explanation for each input and what the default value would be. If you do not input a value for any of these inputs, okay?

They will get some default values and this is all explained here. Okay, so back to our range dot address property, the first input here the row absolute, this takes values of either true or false. Okay, and if this takes a value of true, what's going to happen is that the row part of the reference for your cell so here the reference for your cell is a one, the row part which is the one is going to be absolute and that means that it's going to have $1 sign before you know about absolute and relative references in Excel. This is actually one of the basics in Excel. So if you give this a value of true the real part of your cell reference will have $1 sign before it and the for the column absolute as well. If you give this a value of true, the column part will have $1 sign before it as well.

And actually, you can either put a value of true or you can also put a one okay and you can put a false or you can put a zero okay, so one is equivalent to true, and zero is equivalent to false as well. So let's say I'm going to put the row opposite to be true or one and the column opposite to be true or one as well. And if you put this inside a message boxes, put this inside a message box and see what we got. We're going to actually get dollar sign $1 sign one, so the whole reference for the cell is going to be absolute. So if you run that, you can see here we got dollar sign $1 sign one, okay, and if we, for example, make the column absolute false or zero, that means that the column part which is the a and cell reference, a one is not going to have $1 sign before it so it's gonna be $1 sign one if you run that, can see that okay, of course if we put that as a zero is going to be just a one without any dollar signs.

Okay, so you've got the idea is just it controls how the address is displayed, and whether it's Row part or the column part are absolute or relative. So this is what the row absolute and the column absolute inputs control. Okay? So if you put another comma, and we go to our third input or third argument, you can see here the third input is called reference style as XML reference style. And it takes actually two values either XML a one or XLR one, c one, and these are basically the two ways that you can refer to the Excel cells in Excel. Okay?

So the Excel one is basically the very common way of referring to cells, which is a one a two c one C, two D, one D, two, D two, the XL r one c one style is an obsolete style of referring to cells. It's not used by 99% of Excel users and just don't want to, you know, dive deep into that. So already, I don't want to confuse people. So I'm not gonna dive deep into that, you just stick to the Excel a one style, okay, which is the common style that everybody uses. And this is actually the default value for this input. So if you don't give this input any value, it will default to excel a one which is actually what's required because this is the style used by 99% of the Excel users.

Okay, so now if we add another comma here, we will go to the external input for the range dot address property, and this input takes values of either true or false. And if it takes a value of true, then what's going to happen is that it's going to display the full address for the range including the workbook reference and the worksheet reference as well. Okay, so let's put that as a true or one guy. So true on one or the same basically. And if you're close brackets and we will close the brackets for the message box as well and we run that, you will see here that we get actually the full address for the cell A one. Okay, so you can see here it says range object dot XLS M, which is the name of my workbook and then sheet one, which is the name of the sheet.

Okay, and then the reference for the cell as well. Okay, so this is the full reference, including the workbook and the worksheet references and probably won't use that a lot, but I just wanted you to know what it does, okay, and of course, you could put a false for it, if you put a zero, then it will just display the cell reference and this is actually the default value. So if you don't put anything on that external input, then it will just get the value of false. Okay, so moving on to the relative to input this relative to input axes only used when you put the reference style input to b r1 c one, which is actually the obsolete way of referring to excel cells that 99% of the Excel users do not use. So I'm not going to go into that, okay, because you probably won't use it at all.

So I won't go into that. Okay, so the two inputs that you're going to use most frequently are actually the row absolute and the column absolute. And we've explained them and actually, if you don't put any values in them, they will default to true, that means that both of them will be absolute. So the row and the column references will both be absolute. So if you just write range, a one dot address, even if you don't write the brackets, this will default to true Okay, so if I don't write the brackets, even for the range, that address property and just run it like that inside a message box, you can see here that we get both the row and the column to be absolute. Okay, so one I'll show you something else as well as you write a one, two, C six, for example, address, okay?

And if you run that, actually, the role absolute and the co op suit will default to true, that means you will get a one two c six all absolute the row and the column references, okay. And of course, if you just put both as false the row option and the column absolute, okay, and you run that again here, you'll see here that you've got them as relative, the E One, two c six, whole, the whole reference is relative. Okay, so just to wrap up what the range dot address property does is that it outputs the address for the range that you use it on. And of course, you need to know the difference between absolute and relative references in Excel to be able to understand that range dot address property fully. And if you don't know the difference between the absolute and relative references in Excel, I'd recommend you'd watch a video on it or read an article or something, it should be part of the basics of Excel.

And if you're taking a VBA course and you should be an intermediate to advanced user, but you could watch a video on absolute versus relative references on YouTube or something to be able to understand that fully. Okay, so thanks guys for watching this video and I'll see you on the next one.