Basics of VBA / Macros Chapter – 24 (Loop Part-1)
Loop Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells…
Read article →Markets today
- 1 USD₹93.93
- 1 EUR₹105.33
- 1 GBP₹126.08
- 1 JPY₹0.594
- 1 CNY₹14.08
- 1 CHF₹114.46
Since 2016 · Atul Vij →
Automate your Excel reports
Free tutorials, tested files and tools that run in your browser.
Explore topics
Pick a pocket of knowledge🤯 Wacky fact
Tardigrades have survived being exposed to open space.
These half-millimetre “water bears” can dry out into a dormant state. In 2007 some were carried into orbit on the outside of a spacecraft and exposed to vacuum and radiation; a number of them revived and even reproduced after returning…
Free course
Excel VBA in 15 lessons
From your first variable to UserForms, with a practice workbook that has every macro on a button.
15 of 15 lessons published
Start lesson 1 →Latest articles
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. Below we have bordered Range("B2:C3,C5:E5"). This range has two areas. The comma separates…
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 the union of two or more ranges (borders below…
Read article →Excel Waterfall Chart: Build a Profit Bridge in 2 Minutes
Excel Waterfall Chart: Build a Profit Bridge in 2 Minutes
Show how you got from last year's profit to this year's with an Excel waterfall chart: data layout, setting totals, colours for increases and…
Read article →Why Are Pencils Yellow?
Why Are Pencils Yellow?
Most pencils in America and many elsewhere are painted yellow. The popular story involves Chinese graphite, royalty and a famous Austrian pencil from 1890.…
Read article →Translate Any Web Page, PDF or Photo Into Hindi or English
Translate Any Web Page, PDF or Photo Into Hindi or English
Built-in ways to translate a whole web page in Chrome and Edge, a PDF or Word document with Google Translate, and text in a…
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 and columns away from a certain range (border…
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) a specific number of rows and columns larger or…
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 current region is a range bounded by any combination of blank rows and…
Read article →Income Tax Calculator FY 2026-27 in Excel: New vs Old Regime with Slabs and Rebate Formulas
Income Tax Calculator FY 2026-27 in Excel: New vs Old Regime with Slabs and Rebate Formulas
Download and build an Indian Income Tax calculator in Excel for FY 2026-27 (AY 2027-28). Compare New vs Old Tax Regime, Section 87A rebate,…
Read article →Mastering LAMBDA and LET in Excel: Build Custom Reusable Functions Without VBA
Mastering LAMBDA and LET in Excel: Build Custom Reusable Functions Without VBA
Learn how to use LET and LAMBDA in Excel 365. Eliminate redundant calculations, speed up workbooks, and package complex formulas into custom named functions.
Read article →Migrating Excel VBA Macros to Python: A Step-by-Step Translation Guide
Migrating Excel VBA Macros to Python: A Step-by-Step Translation Guide
Step-by-step roadmap to convert slow Excel VBA macros (.xlsm) into fast, automated Python scripts using pandas, openpyxl, and xlwings.
Read article →