LinkBack URL
About LinkBacks
I want code to delete cells in columns A:E in attachment a so that it looks like attachment b when finished.
Thanks.
I want code to delete cells in columns A:E in attachment a so that it looks like attachment b when finished.
Thanks.
Here you go:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I want to do exactly the same but only to column C. Would you, please, modify the code so it removes duplicates from C only, and post it here?!Originally Posted by JBeaucaire
Here you go:
Please Login or Register to view this content.
Can you also explain where to put this code?!
Thanks for the help.
Last edited by Geir; 04-26-2009 at 04:48 AM.
1. Open up your workbook.Press Alt-F8 to run the macro ClearDupeValues. If it does what you want, great. If not, close book without saving and explain your requirement further. This macro duplicates your results as originally posted, it only does that.
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet.
Thanks for quick reply.
I ran the macro but it produced mixed results. I then took column C only to a new sheet and ran and the macro. It worked!
Is it possible to make this work on the original sheet, but only to remove duplicates from column C only?!
This is for column C only. I made the "C" references easier to spot so you can understand this better and perhaps tweak it yourself.
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]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