Basics of VBA / Macros Chapter – 17 (Select Case Part-1)
A practical VBA lesson to replace a long chain of repeated comparisons with a clear Select Case structure, with complete code, test data, mistakes,…
Read article →Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
Basics of VBA / Macros Chapter – 16 (Logical Operators Part-1)
Basics of VBA / Macros Chapter – 16 (Logical Operators Part-1)
A practical VBA lesson to combine multiple tests with And, Or and Not without creating hidden logic errors, with complete code, test data, mistakes,…
Read article →Basics of VBA / Macros Chapter – 8 (Range Part-2)
Basics of VBA / Macros Chapter – 8 (Range Part-2)
CurrentRegion This example illustrates the CurrentRegion property in Excel VBA. The cur
Read article →Basics of VBA / Macros Chapter – 9 (Range Part-3)
Basics of VBA / Macros Chapter – 9 (Range Part-3)
Resize The Resize property in Excel VBA makes a range (border below for illustration only
Read article →Basics of VBA / Macros Chapter – 10 (Range Part-4)
Basics of VBA / Macros Chapter – 10 (Range Part-4)
Offset The Offset property in VBA takes the range which is a particular number of rows
Read article →Basics of VBA / Macros Chapter – 7 (Range Part-1)
Basics of VBA / Macros Chapter – 7 (Range Part-1)
Range Object The Range object which i
Read article →Basics of VBA / Macros Chapter – 15 (If Else/Then Statement Part-1)
Basics of VBA / Macros Chapter – 15 (If Else/Then Statement Part-1)
A practical VBA lesson to use If, ElseIf and Else to turn business rules into readable decisions, with complete code, test data, mistakes, checks…
Read article →Basics of VBA / Macros Chapter – 6 (Declaring Variables Part-4)
Basics of VBA / Macros Chapter – 6 (Declaring Variables Part-4)
Static Variables Sometimes you want to retain the value of a variable in VBA when a procedure ends. You can achieve this by
Read article →Basics of VBA / Macros Chapter – 14 (Formatting Part-2)
Basics of VBA / Macros Chapter – 14 (Formatting Part-2)
A practical VBA lesson to apply fills, borders and status colours from values while keeping the workbook maintainable, with complete code, test data, mistakes,…
Read article →Basics of VBA / Macros Chapter – 5 (Declaring Variables Part-3)
Basics of VBA / Macros Chapter – 5 (Declaring Variables Part-3)
Variable Scope The scope of a variable in Excel VBA determines where that variable may be used. You determine
Read article →Basics of VBA / Macros Chapter – 13 (Formatting Part-1)
Basics of VBA / Macros Chapter – 13 (Formatting Part-1)
A practical VBA lesson to build a readable report header and apply consistent number formats without selecting cells, with complete code, test data, mistakes,…
Read article →Basics of VBA / Macros Chapter – 4 (Declaring Variables Part-2)
Basics of VBA / Macros Chapter – 4 (Declaring Variables Part-2)
Option Explicit I personally strongly recommend to use Option Explicit at the start of your
Read article →