Basics of VBA / Macros Chapter – 24 (Loop Part-1)
Loop Looping is one of the most powerful programming techniques. A
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Basics of VBA / Macros Chapter – 12 (Range Part-6)
Basics of VBA / Macros Chapter – 12 (Range Part-6)
Areas Collection This example illustrates the Areas collection in Excel VBA. Bel
Read article →Basics of VBA / Macros Chapter – 21 (Second Highest Value Part-1)
Basics of VBA / Macros Chapter – 21 (Second Highest Value Part-1)
A practical VBA lesson to find the second-highest distinct value and define what should happen with duplicates, with complete code, test data, mistakes, checks…
Read article →Basics of VBA / Macros Chapter – 11 (Range Part-5)
Basics of VBA / Macros Chapter – 11 (Range Part-5)
Union and Intersect The Union method in Excel VBA returns a Range object that represents
Read article →Basics of VBA / Macros Chapter – 20 (Mod Operator Part-2)
Basics of VBA / Macros Chapter – 20 (Mod Operator Part-2)
A practical VBA lesson to test prime numbers efficiently and explain why the square-root limit is sufficient, with complete code, test data, mistakes, checks…
Read article →Basics of VBA / Macros Chapter – 19 (Mod Operator Part-1)
Basics of VBA / Macros Chapter – 19 (Mod Operator Part-1)
A practical VBA lesson to use Mod for repeating patterns, grouping and periodic actions, with complete code, test data, mistakes, checks and a downloadable…
Read article →Basics of VBA / Macros Chapter – 18 (Select Case Part-2)
Basics of VBA / Macros Chapter – 18 (Select Case Part-2)
A practical VBA lesson to use ordered Case Is ranges for banded calculations without presenting illustrative rates as current tax advice, with complete code,…
Read article →Basics of VBA / Macros Chapter – 17 (Select Case Part-1)
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 →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 →