Welcome to Learn Excel VBA Macros from Scratch – In Hindi (हिंदी मे)

1. Introduction
1.01 Introduction of Visual Basic for Applications
1.02 Start with Macro Recorder – Create your first Macro
1.03 Assigning the Macro to a button
1.04 Placing a Macro on the Quick Access Toolbar
1.05 Assignment – Macro Recording
1.06 Assignment Solutions – Macro Recording
2. Working with VBE, Range Objects, Range Properties
2.01 Understand about VBE Components
2.02 Writing to cells using Active cell, Range, Cell & offset Property
2.03 Range Properties & methods which you must know
2.04 Methods to find the Last row & Last Column of your range
2.05 Understand the Copy & Paste Method
2.06 Assignment – Copy Paste Method
2.07 Assignment Solution – Copy Paste Method
3. Working with Workbook, Worksheets & Variables
3.01 Overview about Variables & use of Option Explicit
3.02 Learn about Referencing Worksheets & Workbooks
3.03 Assignment – Declare required Variables
3.04 Assignment Solution – Declare required Variables
4. Looping through Collections – Part 1
4.01 With & End with Statement for easy execution of codes
4.02 Learn about For Next Loop
4.03 Apply V-lookup formula with For Next loop
4.04 For Each to Loop through collections
4.05 Assignment – Hide unwanted columns
4.06 Assignment Solution – Hide unwanted columns
5. Looping through Collections – Part 2
5.01 IF Then (Else, Else IF) Constructs
5.02 Controlling Code execution – Go to Statements
6. Looping through Collections – Part 3
6.01 Select Case Constructs
6.02 Do Until Loop through collections
6.03 Do While loop through collections
6.04 Assignment – Select Case
6.05 Assignment Solution – Select Case
6.06 Assignment – Do until loop through collections
6.07 Assignment Solution – Do until loop through collections
6.08 Assignment – Do While loop through collections
6.09 Assignment Solution – Do While loop through collections
7. Error Handling in VBA
7.01 Learn about different types of errors in VBA
7.02 Use of Error Handler
8. Understanding about Excel VBA Events
8.01 Introduction to Events
8.02 Learn about Open Event, Before Close Event
8.03 Learn about Change Event, Selection Change Event
8.04 Learn about BeforeDoubleClick Event, Before Right Click Event
#Bonus Lessons
9.01 Project – Consolidation of different worksheets in one workbook
9.02 Project – Email Automation
VBA FINAL QUIZ
Previous Lesson
Next Lesson

2.02 Writing to cells using Active cell, Range, Cell & offset Property

Welcome to Learn Excel VBA Macros from Scratch – In Hindi (हिंदी मे) 2.02 Writing to cells using Active cell, Range, Cell & offset Property
Previous Lesson
Back to Course
Next Lesson
Scroll to Top