please suggest a programm in vba to remove duplicate values from a row?
a1:a50 remove duplicates.....?
please suggest a programm in vba to remove duplicate values from a row?
a1:a50 remove duplicates.....?
Last edited by yogesh aggarwal; 12-24-2011 at 09:51 AM. Reason: solved
Do a search of the Forum there's numerous code examples for this, eg
Please Login or Register to view this content.
Last edited by royUK; 12-21-2011 at 11:12 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You can use the remove duplicates option available directly in excel 2007 onwards.
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]
thank you for your help "royUK"........
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks