I need a macro that will delete all rows that contains any cells in a string of text, containing this content:
http://www.fanbox.com/PremiumBlogs/M...nts.aspx?coach
http://profile.fanbox.com/Mail/MessageHistory.aspx?with
http://blogs.fanbox.com/PBlogPostMod...spx?ClientUser
Looks like the common text in all the 3 rows is fanbox.com. Is this the only content that needs to be checked or is there a list of such content?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There is a list of links and content, but I need to isolate these three are specific phrases in the string of texts and delete the rows they are on.
1) Create a sheet called STRINGS and put those search strings into column A starting at A1, goign down.
2) This macro will search the ACTIVESHEET for every string in that list and delete those rows
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!)
For some reason, the macro isn't really doing anything. It only deleted one row at a time, not all the rows at once.
Post a sample workbook so I can see your whole scenario. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
File is attached. I just need a macro to delete the excess lines containing certain words/content in a string of text.
Hm, odd. try this:
Please Login or Register to view this content.
Thank you! That completely worked!
I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks