How to delete duplicate rows in Excel automatically using VBA

Channel:
Canada MohanadPC
Subscribers:
1,540,000
Published on ● Video Link: https://www.youtube.com/watch?v=ZnRybDWLosA


Category:
Tutorial
Duration: 2:57
166 views
6

Delete unwanted text or duplicate rows in Excel like a Champ!
VBA Code:
Sub DeleteCells()
For Each c in Range("A1:A10")
If c = "x" Then c.EntireRow.Delete
Next
End Sub

Subscribe to my YouTube Channel as shown in link below to see more videos:-
https://www.youtube.com/c/MohanadPC?sub_confirmation=1

#MohanadPC #VBA #Excel_Tricks #Excel_Tips



Other Videos By MohanadPC


2021-10-30Learn Excel Features (Sort, Filter and Freeze Pane)
2021-10-23How to create/sketch diagrams for free using Lucidchart
2021-10-11How to use Concatenate Function and Sort Feature in Excel
2021-10-06How to print Excel Sheet and still keep it in the proper page format! 🤔
2021-09-25iPhone Tips, how to change website showing at the top of the screen!
2021-09-19Calculate Change% , Markup Price, Markup Price% in Excel
2021-09-11Google Translate App Explained!
2021-09-06Collaborate your work with your team mates easy using Trello- Free, and very friendly workspace
2021-09-02How to use Pivot Table and calculate change in $ in Excel
2021-08-28How to send Excel spreadsheet by email from Excel and how to avoid errors
2021-08-21How to delete duplicate rows in Excel automatically using VBA
2021-08-16Excel Tips -Very Handy Functions (Must Watch)
2021-08-14Excel Tips and Tricks -VLookup Explained in 3 Minutes
2021-08-08Excel trick to delete blank rows in within seconds Automatically using VBA code
2021-08-07How To Use Microsoft Office Free Edition!
2021-08-05Compare two text files Simple\Free using Notepad++
2021-07-25How To Backup your iPhone/Android Data Easily Using Google Photos App!
2021-07-24انقل معلومات هاتفك الايفون او الاندرويد ببساطه الى الكومبيوتر باستخدام كوكل فوتوز
2021-07-24شرح مبسط عن برنامج الايتونز من شركة أبل وشرح طريقتين لنقل معلومات الايفون الى الكومبيوتر Itunes
2021-07-21قطع واعمل مونتاج لأي فيديو بسهوله مع برنامج مجاني من مايكروسوفت Easy/free Video Cutter
2021-07-21How To SpeedUp Your Windows Computer!


Tags:
Excel VBA
Excel Tips
Excel Tricks
How to delete duplicate rows
Microsoft Office Tutorials
Excel Tutorials
MohanadPC
Mohanad