Step 6: Now run the code by pressing the F8 key or by clicking on the Play button. Step 5: Now we assign the variable A with cell Value to see the Sheet name as shown below. Here as we don’t have any header reference so we can start from cell 1.ĭim A As Integer For A = 1 To Sheets.Count ![]() Step 4: Select the position of cell from where we want to see the Sheet names. Step 3: Open a For-Next loop as shown below. We can choose the name variable as we did in example-1. Step 1: Open a Module and write the subprocedure as shown below. Now in this example, we will see another example where we will use the For-Next loop to print the sheet names. ( Note: Press Ctrl+ G to open immediate window) Step 7: This could have been done using Debug Print function as well, whose values are seen in Immediate Window. ![]() We will see the message box with the value 100 in it. Step 6: Run the code by pressing the F8 key or by clicking on the Play Button located below the menu bar. Step 5: Now we will use the message box to print the value stored in Variable A.
0 Comments
Leave a Reply. |