Range("AQ:AQ").AutoFilter 1, "False"
Range("AQ2:AQ" & Cells(Rows.Count, 42).End(xlUp).Row).EntireRow.Delete
I am using this code but i am not getting the desired results.As the rows with duplicate unique id still remains.
Range("AQ:AQ").AutoFilter 1, "False"
Range("AQ2:AQ" & Cells(Rows.Count, 42).End(xlUp).Row).EntireRow.Delete
I am using this code but i am not getting the desired results.As the rows with duplicate unique id still remains.
Did you try using the remove duplicates option in excel 2007?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I know about that but i want to automate it..using a vba code.
Sure, just record your step while doing the remove duplicates step. You will get your code.
Thanks..It was helpful.But again i am caught in a situation.I got the following code by recording
which i modified intoPlease Login or Register to view this content.
to make it more dynamic.but there is a error(run time error '1004') while using this codePlease Login or Register to view this content.
Interchange these 2 - cells(Columns.Count, Rows.Count) It should be rows.count, columns.count)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks