VBA Worksheets and Workbooks: Add, Copy, Loop, Save Safely
Excel VBA course lesson 11: refer to workbooks and sheets without ActiveSheet bugs, loop through every sheet, add and rename sheets, copy sheets to…
Read article →Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
VBA Subs and Functions: Reusable Code and Your Own Excel Formulas
VBA Subs and Functions: Reusable Code and Your Own Excel Formulas
Excel VBA course lesson 10: split a big macro into small Subs, pass arguments ByVal and ByRef, return values with Functions, and build user-defined…
Read article →VBA Arrays: Make Your Macros 100 Times Faster
VBA Arrays: Make Your Macros 100 Times Faster
Excel VBA course lesson 9: read a whole range into an array, work in memory, write it back once. Static and dynamic arrays, ReDim…
Read article →VBA String Functions: Left, Mid, InStr, Replace, Split and More
VBA String Functions: Left, Mid, InStr, Replace, Split and More
Excel VBA course lesson 8: clean and reshape text with VBA — Len, Left, Right, Mid, InStr, InStrRev, Replace, Trim, UCase/LCase, StrConv, Split/Join, Like…
Read article →VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
Excel VBA course lesson 7: read VBA error messages, step through code with F8, use breakpoints, the Immediate and Locals windows, Debug.Print, and handle…
Read article →VBA Loops Explained: For, For Each, Do While and Do Until
VBA Loops Explained: For, For Each, Do While and Do Until
Excel VBA course lesson 6: repeat work with For…Next, Step, For Each over ranges and sheets, Do While/Until loops, Exit For, nested loops and…
Read article →5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
Excel VBA course lesson 5: five small, reusable macros explained line by line — every Nth row with Mod, second-highest value, sum by fill…
Read article →Decisions in VBA: If…Then, And/Or and Select Case
Decisions in VBA: If…Then, And/Or and Select Case
Excel VBA course lesson 4: make macros decide with If…Then…Else, ElseIf, And, Or and Not, check empty and error cells, and replace long If…
Read article →Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Excel VBA course lesson 3: format reports with VBA — fonts, fill colours with RGB, borders, alignment, number formats for Indian rupees and dates,…
Read article →Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Excel VBA course lesson 2: refer to cells with Range and Cells, find the last row and column, move with Offset, grow selections with…
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Excel VBA course lesson 1: open the VBA editor, write your first macro, declare variables with Dim, choose the right data type (Long, Double,…
Read article →VBA Files and Folders + Final Project: Combine a Month of Reports Automatically
VBA Files and Folders + Final Project: Combine a Month of Reports Automatically
Excel VBA course lesson 15: loop through files with Dir, create folders, check whether files exist, read text/CSV files, then build the final project…
Read article →