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 →Atul Vij
Understanding Tax and Stat Reports: A Practical Guide to Reconciliation
Understanding Tax and Stat Reports: A Practical Guide to Reconciliation
Updated with the blank V6.0.5 Excel workbook, usage instructions and validation notes. A practical guide to comparing Tax and statutory accounting data and reconciling…
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 →Why Does India Drive on the Left?
Why Does India Drive on the Left?
India drives on the left because of British rule — but the deeper reason may go back to riders keeping their sword hand free.…
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 →The Story of the ₹ Rupee Symbol
The Story of the ₹ Rupee Symbol
India adopted the ₹ symbol in 2010 after a national design competition. Who designed it, what the shape means, and how it reached keyboards…
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 →The First Thing Ever Scanned With a Barcode Was a Packet of Gum
The First Thing Ever Scanned With a Barcode Was a Packet of Gum
On 26 June 1974 a pack of Wrigley's Juicy Fruit gum became the first product sold by scanning a UPC barcode. How barcodes work…
Read article →Basics of VBA / Macros Chapter – 3 (Declaring Variables Part-1)
Basics of VBA / Macros Chapter – 3 (Declaring Variables Part-1)
Here we learn how to declare, initialize and display a variable in Excel VBA. To tell that we are using a variable is called…
Read article →Why Is Mars Red?
Why Is Mars Red?
Mars is red because its surface dust is rich in iron oxide — rust. How the rust formed, why the sky on Mars is…
Read article →