Hi,
I have a spreadsheet that in the A column I want to delete certain rows that contain the words "blank" "empty" "Apple pies " and completely empty cells ""
I am currently doing this manually by conditional formatting to highlight the cells and then deleting the rows....long tedious work.
In essence, the vba would search column A looking for text "X" "Y" "Z" and empty cell "" and remove the rows that contain them.
I hope this made sense.
Many thanks in advance
Neil
PS The code that I found in post#2 by JMAN of this thread I thought could be adapted http://www.ozgrid.com/forum/showthre…2427#post762427
PPS I also found useful code on this thread using the 'input box' method from Reafidy post #4, but i have to enter search strings separately
http://www.ozgrid.com/forum/showthread.php?t=66221