How to find duplicates in a column using VBA and without using worksheet functions??
I was asked to code on VBA to find duplicates in a column and paste them in other column.
NOTE: 1. If the value has been repeated more than twice, still you should paste the value into the other column only once.
2. Use of worksheets function is not allowed.
Please help me on this ..... thanks in advance.....
Why not? Is this a homework assignment?Originally Posted by himanshu_s
Can you use worksheet functions if they're within a macro?
Hello himanshu_s,
Welcome to the Forum!
If this is a home work assignment then we provide you answers to your questions. However, it is the policy of this forum not to do you work for you.
You can use two nested For Next loops and Array or you can use a single For Next loop and the Dictionary object.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
hello everyone,
actually this question was asked to me during an interview, and since then, I have been thinking about it. So, I have put up this question over here just out of curiosity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks