Next, you need to use VBA IF Statement to test if the name of the sheet that is currently in that loop iteration is NOT EQUAL to the active worksheet, and if this condition is true then hide sheet that is now in the loop iteration.

After that, use “For each” keyword, and then “mySheet” variable for the sheet, and use “ActiveWorkbook.Worksheets” for the collection of worksheets from the active workbook.

First, you need to declare a variable to use as a worksheet.To use For Each Next loop, you can use the following steps:

This code will check each worksheet’s name and match it with the active worksheet’s name and hide it if it doesn’t match. To understand For Each Next loop, let’s write a code to hide all the sheets other than the active worksheet. Next: It’s the end statement for one iteration of the loop and tells VBA to move to the next object in the collection.Įxample to Understand the For Each Next Loop.Statement: Line(s) of code that you want to execute in each loop through all the objects in the collection.Collection: It’s a collection of objects in which you want to loop.With each iteration, moves from one object to the next. Object: It represents the one object in the collection of objects in which you are looping.You can see in the below snapshot, when I run this code it starts from the selected cell by entering a serial number and then moves to the next cell with each iteration. In the end, use the keyword next and the counter variable to end the code for the loop.As the counter value increases in each iteration, you can use it to enter the serial number into the active cell and after that, you can use the offset to move the selection to the next cell downwards. From here you need to write code that can add the serial numbers into the active cell and then move to the next cell.Here in this code, you have the variable “i” as the ending value. Now it’s time to write code for loop, so in the first line, you need to use the counter variable and define starting and the ending value.Next, we need to assign the counter value to the variable.First, you need to declare a variable that you can use to store the counter value.To use For Next Loop, you can use the following steps:

Vba increment variable