I am doing a task where a macro that searches a word where a box pops up appears then you can search the word in column D. The word can occur multiple times in the column. It finds that word it deletes the contents in the row from the cells from bc to gg. This macro should keep all of the text before rows bc and only delete the words in a rows from bc on where the word is found. Please help me with this. Thank you
Bookmarks