Introduction to Excel VBA | Excel VBA series lesson-1| Excel VBA Beginners tutorial in hindi
HTML-код
- Опубликовано: 22 июн 2024
- Welcome to the first part of our VBA Programming Tutorial for Beginners series! 🚀 In this video, we dive into the basics of Visual Basic for Applications (VBA), the powerful programming language used to automate tasks in Microsoft Office applications like Excel, Word, and Access.
🔍 What you'll learn in Part 1:
What is VBA and why you should learn it
Setting up the Developer tab in Excel
Introduction to the VBA Editor
Writing your first VBA macro
🌟 Whether you're looking to streamline repetitive tasks, create complex automation solutions, or just expand your programming skills, this tutorial is the perfect starting point.
👍 Don't forget to like, comment, and subscribe for more VBA tutorials!
💬 Have questions? Drop them in the comments below and I'll do my best to help!
#VBA #VBATutorial #ExcelVBA #Programming #Automation #ExcelTutorial
Nice way of teaching ...
Sukriya 😊
Nice sir❤😊
Thank you 😊
Series wise upload kijiye sir please
Support hum karenge
Meri Puri Kosis rahegi ki aap logo ko series wise video ....Keep supporting sir.
@@ProgramMaster338 okay sir
Dear sir please help
Please note that I have an excel workbook which has four sheets Jan, Feb, Mar, Apr, the data in these four sheets is different columns, how can I marge these 4 sheets in one singel sheet on different workbook threw vba pls help
Sub CombineSheets()
Dim ws As Worksheet
Dim combinedSheet As Worksheet
Dim lastRow As Long, combinedLastRow As Long
Dim sheetName As String
' Add a new sheet to store combined data
Set combinedSheet = ThisWorkbook.Sheets.Add(After:= _
ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count))
combinedSheet.Name = "MergedData"
' Loop through each sheet in the workbook
For Each ws In ThisWorkbook.Worksheets
' Skip the combined sheet itself
If ws.Name combinedSheet.Name Then
' Get the last row of data in the combined sheet
combinedLastRow = combinedSheet.Cells(Rows.Count, "A").End(xlUp).Row
' Get the sheet name
sheetName = ws.Name
' Loop through each row of data in the current sheet
For lastRow = 1 To ws.Cells(Rows.Count, "A").End(xlUp).Row
' Copy data to the combined sheet
combinedSheet.Cells(combinedLastRow + lastRow - 1, 1).Value = sheetName
ws.Rows(lastRow).Copy Destination:=combinedSheet.Rows(combinedLastRow + lastRow - 1)
Next lastRow
End If
Next ws
MsgBox "All sheets combined successfully!", vbInformation
End Sub
This code is generally used to combine your sheet in one sheet automatically with named merged cell.
I hope you will get your questions answer .... We will discuss this topics in our upcoming class ..
Keep supporting us..
Thank You