Automation in Excel is about code that performs different tasks automatically when an event has happened. This category includes free templates like code to create a new worksheet and code to calculate the number of rows for instance.
Here you can download free code that shows how a DO UNTIL loop can be used for programming in Excel and VBA when you need to iterate through a data list of values until a condition is met.
Here you can download free code that shows you how a DO WHILE loop can be used for programming in Excel and VBA when you need to iterate through a data list of values as long as some condition are met.
Here you can download free code that gives you two examples of how a FOR loop can be used for programming in Excel and VBA.
Here you can download free code that shows you how built-in Excel functions and Excel formulas can be used in VBA for calculations and searches in a worksheet.
Here you can download free code to calculate the number of used columns and used rows in a worksheet in Excel.
Here you can download free code to create a new worksheet and to delete worksheets in Excel using VBA to be able to automate such tasks in programs for Excel.
Here you can download free code to refer to ranges and cells in a worksheet in Excel in order to be able to get data, manipulate data and present data in a worksheet.