Hellow every body,
I'm looking for your kind help.
I have a table of 30 columns. it starts at "A7". I'm lokking for (1) automatic removal of duplicate rows. (2) removal of blank row. In "Developer"/ "View Code". I put this macro for automatic removal of duplicate rows but it does not work.Thank you so much in advanceHTML Code:
Please send a short sample file of your data:
- Battle without fear gives no glory - Just try
Hi karimretina,
I have modified your code a little bit, kindly check below code. Also Check the attached file and hope it will help you.
Please Login or Register to view this content.
Removal of DuplicateRows.xlsm
Note: I have taken data till column H, hence my array is from 1 to 8. Please change it as per your requirement.
Regards,
Paresh J
Last edited by pareshj; 07-03-2014 at 03:24 AM.
Click on "* Add Reputation" as a way to say thanks
Hello,
My name is Manoj Nayak. I am keen to learn VB user form. can somebody guide me.
Hi pareshj,
Thank you so much for your help. I tried the modification you suggested but it unfortunately does not work
is there any alternative?
Thank you so much
karimretina,
Here again send an example of your data it will helps to prepare an answer
PCI
Hi karimretina,
Please attached the workbook you have worked on, I will try to do some corrections and and we can check then.
Regards,
Paresh J
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks