![]() The code then removes all the rows from the range that contain duplicate product names. ![]() In the above code, we specified this as Column 1 or the Product Names column. ![]() It takes the selected range, as well as the columns that you want to base the duplicate removal on. This code uses a VBA built-in command for removing duplicates in list-objects. Rng.RemoveDuplicates Columns:=Array(1), Header:=xlYes If you are comfortable with a little coding, then you can use this method to remove duplicate rows based on a single column.Įven if you’re not that keen on coding, you can just copy-paste the following code: Sub Delete_duplicate_rows() So instead, you can have the code and add it to the Quick Access Toolbar, so that you can access it with a single click. This method is useful when you have to do this quite often and don’t want to follow many steps. You can do this easily using a short VBA code as well.
0 Comments
Leave a Reply. |