LinkBack URL
About LinkBacks
I am using the follwoing code which works as it is supposed to except that it does not remove the duplicate entries, almost as though the code skips that step. How can I fix this?
Please Login or Register to view this content.
I am using the follwoing code which works as it is supposed to except that it does not remove the duplicate entries, almost as though the code skips that step. How can I fix this?
Please Login or Register to view this content.
Last edited by nsorden; 07-24-2009 at 01:08 PM.
Try adding explicit references to your Cell references.
And all the other places in your code where you use CELL without a preceeding dot referencePlease Login or Register to view this content.
I tried it but it is still failing to remove the duplicates. I have tried switching the order of the sort and duplicate removal, but it does not seem to work.
You need to post example workbook to illustrate your problem
Sample workbook is attached.
I think the problem is actually in the line:
It is not counting correctly and therefore is not producing any duplicates to be removed.Please Login or Register to view this content.
These changes at least get the macro to run.
Is your problem still there, as I don't really know what I'm looking for in your data set.Please Login or Register to view this content.
Yes the Countif and Right functions were working at the same time-producing no duplicates. I made the following change:
Thanks for your time.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks