VBA Code to Merge and Unmerge Cells | Excel VBA Tutorial in Hindi
VBA Code to Merge and Unmerge Cells | Excel VBA Tutorial in Hindi
For online classes, please contact us at 93100 73387
You can Merge Unmerge Cells Range in Excel VBA, it is required if you want to make bigger cells, instead of existing cell to fit your data and needs.
🔴 Subscribe for more videos just like this: https://bit.ly/2PUQwXk
🎧In this video, you will learn
►How can you merge multiple cells to make a bigger cell
►How can you unmerge merge cell to multiples cells according your requirement
►How can you merge multiple rows in to a single row
►How to merge multiple columns into a single columns
►Merge & Center
Download Excel Macro File For Practice 👉 https://github.com/AutomationFever/Sh...
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🖥️Video Summary 👉
📋Merge Cells→
You can Merge Unmerge Cells Range in Excel VBA, it is required if you want to make bigger cells, instead of existing cell to fit your data and needs. Merge Method is used on Range Object to merge cells.
Range("E2:G2").Merge
📋Merge & Center→
Unlike Excel, there are no direct method for merge and center. You need explicitly align your text center post merging cells.
Range("E2:G2").Merge
Range("E2:G2").VerticalAlignment=xlCenter
📋Unmerge Cells→
Unmerge method of Range Object will be called on Range to unmerge merged cells.
Range("E2:G2").Unmerge
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
Hope you found this video useful. Please like, share and subscribe to our channel. This will motivate us to create more good contents. Thanks!
🎬Watch our most recent videos: / automationfever
💜You Might be Interested in (Free Tutorials):
Basic VBA Tutorials (Hindi)👉 • Why Should Learn VBA | VBA क्यों सीखे...
Advanced VBA Tutorials (Hindi)👉 • Send Outlook Mail in VBA | VBA Outloo...
Excel VBA Projects (Hindi) :👉 • Add & Change Sheet Tab Color of 50 Sh...
VBA Outlook Automation (Hindi)👉 • Send Outlook Mail in VBA | VBA Outloo...
Excel Tips & Tricks (Hindi)👉 • Copy From Clipboard - Excel Tips & Tr...
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🎧Do watch our Other VBA Videos (Hindi) 👉
Auto Format 👉 • Auto Format in VBA | Excel VBA Tutori...
Remove Duplicates 👉 • VBA Code to Remove Duplicates | Excel...
Insert Rows 👉 • Insert Rows in Excel Using VBA | Exce...
Insert Alternate Rows 👉 • Insert Alternate Rows in Excel Using ...
Delete Rows 👉 • Delete Rows in VBA | Excel VBA Tutori...
Delete Column 👉 • VBA Code to Delete Columns in Excel |...
VBA Code To Apply Text to columns - Fixed Width 👉 • VBA Code To Apply Text to columns - F...
Delimited Text to columns 👉 • VBA Code to Apply Text to Columns - D...
Advanced Text to columns Tricks 👉 • Advanced Text to Columns Tricks in VB...
Arrays 👉 • Using Arrays in VBA | Excel VBA Tutor...
Dynamic Arrays 👉 • Dynamic Arrays in VBA | Excel VBA Tut...
Autofit Columns Width 👉 • VBA Autofit Cell Content | Excel VBA ...
With Statement 👉 • VBA With Block | Excel VBA Tutorial i...
Custom List 👉 • Custom List in VBA | Excel VBA Tutori...
Status Bar 👉 • Status Bar in VBA | Excel VBA Tutoria...
Finding Last Row or last Column 👉 • Find the Last Row or last Column in V...
Hide Scroll Bar 👉 • Hide Scroll Bar in VBA | Excel VBA Tu...
Change Row/Column Width & Height 👉 • Change Row/Column Width & Height in V...
Change text Orientation 👉 • Change Text Orientation in VBA | Exce...
Insert, Delete, Edit, Read Comments 👉 • Insert, Delete, Edit, Read Cell Comme...
Wrap Text 👉 • VBA Wrap Text | Excel VBA Tutorial in...
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
-------------------------------SOCIAL-------------------------------
🛠️ If you have any doubt or query, drop us an email: [email protected]
🌎Website : http://www.automationfever.com/
👥Facebook: / feverautomation
🐦Twitter: / automationfever
📸Instagram: / automationfever
📕Blogger : https://automationfever.blogspot.com
----------------------------------------------------------------------
#MergeCellsInVba #MergeRowsInExcelVba #excelvba #learnvba #excelvbatutorials #automationfever #MergeColumnsInVba #mergecellsinvbacode #mergecellsinvbaexcel #mergecellvbaexcel #mergecellsusingvba #vbacodetomergecells #excelvbacodetomergecells #vbacodeformergecells #mergecellsvbacode #howtomergecellsusingvba #mergecellsinexcelvba #mergerowsinvba #vbacodetomergerows #vbamergerows #vbamergecolumns #howmergecolumnsinvba
#unmergecells