The below code is used to search the cells in column A for a certain text "String1" if the string is found the entire row is deleted. How does the code have to be if I wanted to search more than one string? I have tried this using a comma to separate the strings ex: String1,String2 but this did not work. Any help greatly appreciated .
Please Login or Register to view this content.
One way
Please Login or Register to view this content.
Last edited by mike7952; 09-02-2014 at 12:05 AM.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Am getting Identifier to long error. I have about 100 or less stings I'm trying to work with.
Maybe you can list the string down column A on another sheet and this will work
Please Login or Register to view this content.
So in A1 of the next sheet (sheet2) I would put the full string in this format "string1","string2" ?
What part of the code would have to be changed if I want to search column C instead of A?
I would put the strings in cell by themself Cell A1 = String 1, A2= string2,A3 = string3 ect...
You can change the range below in the red
Please Login or Register to view this content.
that will not work for me. It would have to be stings in a continuous line like the original code you gave.
Give this a try
Please Login or Register to view this content.
Okay thanks, what part of the code needs to changed to search column C instead of A of the sheet I'm running the macro on?
At the top of code change a to c
Please Login or Register to view this content.
Last edited by mike7952; 09-02-2014 at 02:05 AM.
Yeap that seems to work! Thanks for the help really appreciate it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks