Automation | Category

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.

Built-in Excel functions and formulas (VBA and VB6) | Free code

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.

Calculate the number of used columns and rows in Excel (VBA and VB6) | Free code

Here you can download free code to calculate the number of used columns and used rows in a worksheet in Excel.

Create a new worksheet and to delete worksheets in Excel (VBA and VB6) | Free code

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.

DO UNTIL loop in Excel (VBA and VB6) | Free code

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.

DO WHILE loop in Excel (VBA and VB6) | Free code

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.

FOR loop in Excel (VBA and VB6) | Free code

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.

Refer to ranges and cells in Excel (VBA and VB6) | Free code

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.