Hi,
i'm figuring on how to delete the entire row if a certain column that doesn't contains "132" and any alphabetic characterss, the cell must also have a string length of 13.
(1)0132000000704
(2)1862072
(3)R132000000704
In this scenario, rows (2) and (3) must be deleted because in (2) it doesn't contain 132 and is shorter than 13 characters and (3) because it contains "R" even though it matches the string length of 13.
Thanks for helping!
Last edited by dyiehster; 10-23-2012 at 12:58 AM.
Hi, Dyiehster
maybe something like this
Please Login or Register to view this content.
Hi, Nilem
It worked! but i think there is one entry that is not deleted. Maybe i have overlooked the possibilities. This entry "00/4411263132" was not deleted. is there a way we could delete also when a cell contains special characters?
Thank you so much!
hi for alpha and special characters....
please click the star if it helps...thanks...^_^...Please Login or Register to view this content.
GREAT!! Thanks so much again! now i can proceed. Can i contact you incase i need something else?
mark it solve if its solve your problem...^_^...
one last question. when applying the code into my data which is composed of 115 thousand rows. I keeps on hanging.. changed the A2:A10 to just simply A:A. i think the problem exists in this line of code Set rDel = Range("B1") since I tested it into just one column and in my actual data i have several columns.
try this
Note: create a copy of your working file to test the code.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks