Hi,
I need to build a macro which will look for a specific word say :"ABC" in a particular column say "B" and delete 5 rows including the row containing the word "ABC"
Does anyone have any idea how this can be done?
Thanks.
Hi,
I need to build a macro which will look for a specific word say :"ABC" in a particular column say "B" and delete 5 rows including the row containing the word "ABC"
Does anyone have any idea how this can be done?
Thanks.
Last edited by excelaspire0219; 01-27-2009 at 06:41 PM.
Hello excelaspire0219,
Here is macro to delete the 5 rows if the search word is found in column "B".
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 Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Or
Please Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Hello and thanks VBA Noob!! When I try to run the macro it does not do anything - I'm not sure if I need to change anything in the macro before I use it my spreadsheet?
Try Leith code and if that doesn't work post a sample file
VBA Noob
Ohh I am sorry I thought both the codes were posted by you I apologize for that Leith. Thanks VB Noob and Leith - it worked!!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks