Hi All,
I have recorded a macro for the column A to remove the duplicates; and this works fine. But can someone tell me a method by which I can use this macro to remove duplicates in other columns?
For example, if I select column X, and execute this macro, all the duplicates in column X are removed.
The macro code:
Thank you in advance for your assistance in this matter.
Please Login or Register to view this content.
Streetcat
Last edited by streetcat; 01-23-2012 at 02:55 AM. Reason: Compliance with the guidelines of this forum
Strange, I have not received even a single response. I though the solution will be very simple for the excel gurs!
If you are going to select the column and then run the macro, you can do this -
Please Login or Register to view this content.
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]
@arlu1201 --thanks for your help. This solution works well for my problem :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks