Copy/Paste Remove Duplicates
Hi all again. I need help on the following code
Instead of the "Clearcontent" in the code above in red.
Please Login or Register to view this content.
I need help on a code that will remove all the duplicate lines in the end.
So it copy/paste and the check for duplicate lines and remove them save
Thanks in advancePlease Login or Register to view this content.
Last edited by Rage; 11-10-2009 at 10:04 AM.
Why can't you use the 'Remove duplicates' option of Excel 2007 or 'Advance Filter -> Uniques Records Only' option of previous excel versions to remove duplicates? Or if it is to do it only thru macro then I think using dynamic arrays may help.
Yes it is to do only trough the macros.
As for arrays... ah... :P i have no idea how to
Re: Copy/Paste Remove Duplicates
Helpeeeeplease
Ok after thinking a bit, i need the code to add up to my other sheet instead of clearing the contents.
Any help would be welcome.
Bump, A little help needed. Ty
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks