Alright guys, so now in this section we're going to start dealing with worksheets. So we're gonna learn how to deal with worksheets and the first thing we're going to learn is actually selecting worksheets. Okay, so when you're selecting worksheets, if you need to select a certain sheet, you actually need to call the worksheets collection, and then tell Excel which sheet you would like to select. So here, I'm going to call the worksheets collection object and then tell the worksheets collection object that I need sheet one from that collection. Okay, as we have described before in the introduction lecture on how the syntax of VBA works. So here there is a collection, you're going to call one member of the collection, which is sheet one, and then you're going to write dot select.

So this is a method select a method. So this We'll make use select sheet one, you can see here I've got two sheets in this workbook, sheet one and sheet two. So I'm going to actually select sheet two here and then I'm going to run this code. And this will select sheet one as you can see here. Okay guys, so now we've seen how we could select a worksheet with the worksheet dot select method. But I actually wanted to show you something else about the Select method as well, which is that there is a parameter in the Select method called replace.

And I'm here on the page for the worksheets dot select method on the Microsoft directory network, which I actually got by googling because highlighting it in the VBA editor and pressing f1 did not get me to that page for some reason, but I just googled worksheet dot select method MSDN and I was able to get that so you can see here there is actually a replace parameter. What this replace parameter does is that it allows us to select several sheets at the same time. So remember guys parameters are like adverbs, they actually describe how the verb is done. So this is actually going to describe how the dot select method, which is considered a verb, you know, as we're mimicking the structure of the English language as we've explained before, so the Replace is going to describe how the dot select method is going to be done.

Okay? So if you put replace equal to false, this means that there's not going to be a replacement when you do another selection. So that means that you're going to select multiple sheets at the same time. But if you put an equals to true, then that means that you will not be selecting multiple sheets at the same time. And it's actually this true is the default value for the Replace parameter. Okay, so let's go back to the Visual Basic environment and see that in action.

Okay, guys, so we're back to the Visual Basic environment. So let's say I want to select shih tzu in addition to sheet one at the same time. So you can actually select two sheets at the same time, you can do it in the Excel environment. If you press control, you know, select one sheet, press control and select the other one, you're going to select two sheets at the same time. So we want to be able to do that in Visual Basic as well. I'm just going to ungroup them to be able to just select sheet one.

So let's say I wanna select sheet two in addition to sheet one. So I'm going to right worksheets, sheet two dot select, and then I'm going to press space and I'm going to write the Replace parameter. So I'm going to write replace, colon equals false. Okay, so the Replace parameter when you set it equal to false, you're going to actually be able to select both of these sheets at the same time. So actually, the first selection is going to happen. And then the second selection will have the parameter replaced equals to false and that means that it's going to In addition to the first selections, if you run that, you can see here the both sheets have been selected at the same time.

So if you actually add a third sheet, you can also select it this way. So you can select the three sheets at the same time. So if you add a line, so I'm just going to copy that and just replace it with sheet three, you can select the third sheet as well. So if you keep adding the selection lines with replace equals to false, you're going to be able to select that particular sheet in addition to the sheets previously selected, okay. And of course, if you put to replace equals to true, then your sheet will not be selected, in addition to the other sheets, but it's actually equals to true by default, if you're going to set it equal to true you're not going to write it right but if you run that with you know without putting the replace or by putting the Replace equals to true, then actually it will just select sheet one and then select sheet two, but when when I select sheet two, it's going to D select sheet one and then was the Lucky Three and when it selects sheet three is going to be select sheet two.

So that means that in the end, you will just have sheet three selected because it's just gonna select sheet one and then select sheet two and then select sheet three, we can run it actually step by step by pressing f8. So here, if you run that line of code is going to select sheet one, and then if you run, the second one is going to select sheet two and then if you run, the third one's just going to select sheet three, so it's just selects them exclusively so the newly selected sheet does not get added to the old sheet. So that's it for the worksheets dot select method. This is one of the basic things that you will need to learn when dealing with sheets, which is how you can select sheets. Okay, thank you very much for watching this video and I'll see you on the next one.