Hey guys, welcome back. So in this video, we're going to have more examples for the for each loop. So we're going to see how to loop through more types of objects. Okay, so let's see how to loop through a range of cells. So a range of cells is a collection that contains cells because a range is a collection of cells, the range does not contain anything but cells. So if we want to loop through a range of cells, we need to first of all create a range object, so dim see as range for example here, and I need to see because it stands for cells, but you can name it anything.
And then we would write a for each loop. So for each C in range, and let's say I want to loop through the range of cells, between a one and a 10. So range cells, one comma one and cells 10 comma one, next C. So this is our for each loop. So first of all, we will select that particular cell. And then on that cell, we could put, for example, the row number. So C dot value is equal to c dot row.
So what's going to happen here is that we're going to move through the range of cells between a one to a 10. We're going to select each cell and we're going to put the row number for that cell in that particular cell. So let's go through the code step by step here. So as you can see here, looping through, we're going to select cell A one, currently we are in sell a one and then we're going to put one here and sell a one and then we're going to go to sell a two and select it. And we're going to put to install a two and if we keep on executing the code here, it's going to go through each cell and put the row number for that particular cell in that cell. Okay, so this is A simple example on how to loop through a range of cells.
By the way, if you remove here, the line of code for creating an object variable as a range, this will work as well. But on your code, you will not have the autocomplete feature here. So you will not have suggestions on what properties or methods are for that see object here that you're using. And, by the way, Excel VBA will still recognize this as a range object, even if you don't declare it as a range object because excel vba understands that if you are looping through a range of cells, then each one of them is a range or a cell basically. So even if you do not declare it will still work. But of course, it's a better practice to declare your variables.
Okay, so let's have another example on how to loop through workbooks. So to loop through workbooks, it's the same idea as well. So we will declare a way workbook objects or dim web as workbook for example, so declared a workbook object variable. And then we would say for example, for each web, in workbooks next web. And please note that this would loop through workbooks that are currently open. So the workbooks you're looping through need to be already open.
So what we would do, for example, is that we would have a message box web dot name, and currently I've got two workbooks open, I've got the workbook for the for next loop and the workbook for the for each loop. So if I run this step by step so if I step through the macro, we're going to display the name of each workbook so now we've got the for each loop workbook and then the for next loop workbook and displayed their name. And then there are no more open workbooks. So we're going to exit the loop and and sub So we've seen how to loop through different types of collections we've seen how to loop through worksheets and seen how to loop through a range of cells. And we've seen how to loop through a collection of workbooks. And this same concept can be applied to any other collection in Excel VBA.
So you can loop through a collection of pivot tables and you can also loop through a collection of charts and so on and so forth. Also, please note that you can use the exit for statement with the for each loop the same way that you can use it with the for next loop. So you can use the exit for to exit your loop at any point. So that's it guys for the for each loop. Thank you very much for watching this video and I'll see you on the next one.