We’ve spent several Excel Videos looping through rows and columns in a worksheet. Excel Video 428 has a way to loop through Excel objects in your workbook. It’s easy to see the five worksheet names in this Excel workbook, but if you had 20 or 30 tabs, here’s a way to count the number of worksheet tabs and then loop through each tab to get the name of the worksheet. We’ll put the results in another message box, similar to the last Excel Video.
For...Next is not the only way to loop in Excel. Stay tuned. Next time I’ll show you another way to loop through data with VBA.