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 →Basics of VBA / Macros Chapter – 2 (Creating Macro)
Basics of VBA / Macros Chapter – 2 (Creating Macro)
With VBA you can automate tasks in Excel by writing so called macros. We will learn how to create a simple macro which will be…
Read article →Split Text by Comma, Dash or Any Delimiter in Excel (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)
Split Text by Comma, Dash or Any Delimiter in Excel (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)
Break “Mumbai-MH-400001” or comma lists into columns and rows with TEXTSPLIT, TEXTBEFORE and TEXTAFTER in Excel 365, and the TRIM/MID/SUBSTITUTE trick for older versions.
Read article →Back Up Your Windows PC: OneDrive Folder Backup and an External Drive
Back Up Your Windows PC: OneDrive Folder Backup and an External Drive
Two simple layers of backup for a Windows PC: OneDrive folder backup for Desktop, Documents and Pictures, plus File History to an external drive…
Read article →Basics and Abbreviations of VBA / Macros Chapter – 1
Basics and Abbreviations of VBA / Macros Chapter – 1
VBA full form is Visual Basic for Applications. It is the programming language of Excel and other Office programs. Points to be learned for…
Read article →Using AI to Write Excel Formulas: A Safe 5-Step Checklist
Using AI to Write Excel Formulas: A Safe 5-Step Checklist
AI assistants are great at Excel formulas — when you give them the right details and test the result. A five-step checklist with an…
Read article →Stop Spam Calls and SMS in India: DND, Spam Filters and Chakshu
Stop Spam Calls and SMS in India: DND, Spam Filters and Chakshu
Cut down telemarketing and scam calls: register on TRAI's DND via 1909, turn on your phone's spam protection, block senders, and report fraud through…
Read article →VBA Plus / Macros Chapter – 1 (Swap Values – 1)
VBA Plus / Macros Chapter – 1 (Swap Values – 1)
This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs
Read article →Dependent Dropdown Lists in Excel (Two Methods That Actually Work)
Dependent Dropdown Lists in Excel (Two Methods That Actually Work)
Create a second dropdown that changes with the first — Category then Product, Country then City — using INDIRECT with named ranges or a…
Read article →