![]() 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. ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |