Quickly Merge Cells with Same Values in Excel|Merge formatting|VBA code to|
Download sheet is https://drive.google.com/open?id=1JC-...
Quickly Merge Cells with Same Values in Excel|Merge formatting|VBA code to|#AskmeAnythings|Live|
Code is given below.
Option Explicit
Sub Merge_Same_Cells()
'Excel My Life
Application.DisplayAlerts = False
Dim rng As Range
MergeCells:
For Each rng In Selection
If rng.Value = rng.Offset(1, 0).Value And rng.Value "" Then
Range(rng, rng.Offset(1, 0)).Merge
Range(rng, rng.Offset(1, 0)).HorizontalAlignment = xlCenter
Range(rng, rng.Offset(1, 0)).VerticalAlignment = xlCenter
GoTo MergeCells
End If
Next
End Sub
Quickly Merge Cells with Same Values in Excel|Merge formatting|VBA code to|
advance excel,vba macro,bi dashboard,excel dashboard,personal macro in excel,vba macro in excel,excel tips and tricks with pk,advanced vba course,vba tutorial for beginners,pk’s utility tool,marge same cells using vba,label in vba module,for loop in vba,for each loop in vba,for each rng in selection,merge range using vba,horizontal alignment using vba,vertical alignment using vba
how to merge cells automatically in excel
#Excelmylife #Exceltotally #Exceltipstricks
Social Media Handles:
Follow us on Facebook: / excel-my-life-2093491420725526
Follow us on Twitter: https://twitter.com/ExcelMyLife2?s=08
Follow us on Instagram: https://www.instagram.com/invites/con...
Official website:http://excelmylife.in/
To Subscribe our YouTube channel here: / @excelmylife1565
Thanks for watching
Don't forget to - LIKE | SHARE | COMMENT | SUBSCRIBE
WATCH our OTHER USEFUL VIDEO
======================================
Tally Customization without TDL special Videos playlist:
1. for complete GST tutorial in Tally ERP9 in Hindi
2. For complete Tally ERP 9 tutorial in Hindi
3. for complete CorelDRAW tutorial in Hindi
4. For Photoshop cs2, cs3, cs4, cs5 cs6, & cc tutorial in Hindi
5. complete Pagemaker tutorial in hindi
6. complere MS-Excel 2010 tutorial in hindi
7. complete MS-Word 2010 tutorial in Hindi
8. SSC exam preparation video
9. MS-Access 2010 tutorial
10. Windows 7 tips and tricks and secrets
11. MS publisher tutorial in Hindi
12. Youtube video editing tutorial