VBA String Functions: Left, Mid, InStr, Replace, Split and More
Clean and reshape text in Excel VBA with Left, Right, Mid, Len, InStr, Replace, Trim, UCase, Split and Join — with real data-cleaning examples.
Read article →Tag Archives: 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
Handle errors in Excel VBA properly with On Error GoTo, find bugs with breakpoints, Watch and the Immediate window, and write comments that help.
Read article →VBA Loops Explained: For, For Each, Do While and Do Until
VBA Loops Explained: For, For Each, Do While and Do Until
Learn every Excel VBA loop — For…Next, For Each, Do While, Do Until — when to use each, how to exit early, and how…
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
Five small, useful Excel VBA macros explained: the Mod operator, finding the second highest value, summing by cell colour, deleting blank rows and highlighting…
Read article →Decisions in VBA: If…Then, And/Or and Select Case
Decisions in VBA: If…Then, And/Or and Select Case
Make Excel macros decide: If…Then…ElseIf, logical operators And/Or/Not, and Select Case — with real examples and common mistakes.
Read article →Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Excel cells from VBA: fonts, fill colours, borders, number and date formats, alignment and conditional formatting — with copy-paste examples.
Read article →Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Everything you need to read and write cells in Excel VBA: Range vs Cells, Offset, Resize, CurrentRegion, rows and columns — with practical examples.
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Learn how to declare variables in Excel VBA, choose the right data type, use Option Explicit, and avoid the mistakes that cause type mismatch…
Read article →