Use FOR NEXT Loop in Workbook objects in VBA
The VBA Excel For Next loop can be used to manipulate workbook objects like renaming worksheets, save workbook, entering data in selected cell, etc. The VBA Excel FOR NEXT statement is used to create a FOR loop so that you can execute VBA code a fixed number of times.
In this Excel VBA example you will learn how to rename worksheet with FOR NEXT Loop , enter data in active selected cells. You will learn to refer to workbook objects like worksheet, cell, font, font color, save worksheet, etc., with VBA in Excel.
To learn more about Excel Macros please visit http://www.myelesson.org/vba-training-videos/