hasng.blogg.se

In this example, we will see how to remove duplicate values from more than one column. Once done then click on the Play button to run to code as shown below.Īs we can see, the duplicate number is deleted from column A and the only a unique count is left. Step 8: Now compile the code steps by pressing the F8 Key. Step 7: Now we will use the Header command which will move the cursor to the topmost cell of the sheet, which is mostly in the header of any table.ĪctiveSheet.Range("A:A").RemoveDuplicates Columns:=1, Header:=xlYes If there are more columns then the number will be added and separated by commas in the brackets as (1, 2, 3,…).ĪctiveSheet.Range("A:A").RemoveDuplicates Columns:=1,

This will activate the command to remove the duplicate values from the sequence of the columns 1. Step 6: Now use RemoveDuplicate function here. Step 5: Now select the range of the cells in a currently opened sheet as shown below. Range(Selection, Selection.End(xlUp)).Select It will go down till we have the data in a particular column.

Step 4: Now we will select the Range of selected cells or columns A. For this, in VBA we will Selection function till it goes down to select complete data list as shown below. Step 3: In the process of removing the duplicate, first we need to select the data.