Wrote the below VB and it worked once but I may have made a mess of things with a series of Cut and Pastes. Want Excel to find specific phrases or words in a specific column and delete them.
Please Login or Register to view this content.
Attachment is included
Last edited by billkelley; 10-09-2009 at 03:37 PM. Reason: correct code tags "#"
Hello billkelley,
Aside from shortening your code a bit and preventing an error when deleting rows, I don't see any problems with it. What is not doing?
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks