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-course
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 →