Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
This practical VBA exercise explains one small technique at a time. Work in a copy of your workbook, use Alt + F11 to open…
Read article →Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
⚡
← Excel
Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
📄 52 articles⬇️ 35 with practice files🕒 Updated 12 Nov 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →Basics of VBA / Macros Chapter – 23 (Delete Blank Cells Part-1)
Basics of VBA / Macros Chapter – 23 (Delete Blank Cells Part-1)
A practical VBA lesson to remove genuinely blank records safely without skipping rows or deleting formula results unexpectedly, with complete code, test data, mistakes,…
Read article →Basics of VBA / Macros Chapter – 43 (String Manipulation Part-5)
Basics of VBA / Macros Chapter – 43 (String Manipulation Part-5)
This practical VBA exercise explains one small technique at a time. Work in a copy of your workbook, use Alt + F11 to open
Read article →VBA Runtime Error 1004: Complete Troubleshooting & Code Fixes
VBA Runtime Error 1004: Complete Troubleshooting & Code Fixes
Run-time error '1004': Application-defined or object-defined error is the most common and frustrating error encountered by VBA developers
Read article →Basics of VBA / Macros Chapter – 22 (Sum By Colour Part-1)
Basics of VBA / Macros Chapter – 22 (Sum By Colour Part-1)
A practical VBA lesson to sum values by displayed colour while understanding why colour is a weak data field, with complete code, test data,…
Read article →Basics of VBA / Macros Chapter – 24 (Loop Part-1)
Basics of VBA / Macros Chapter – 24 (Loop Part-1)
Loop Looping is one of the most powerful programming techniques. A
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 – 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 – 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 – 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 – 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 →