Forum Discussion
Deleting rows conditionally
I am trying to automate a particular function in Ms Excel 2013 (and later). The details are as follows: If a particular field has a particular string, I would like the entire row to be deleted. ...
pls see attached sample..
- Hey, the code works well with the file you have attached. However, it doesn't really work with what I have in place. My field of concern is the between E-I, this is where the string will be checked, and the needful should be done
- do you mean to check rows between Columns E to I?
to check these 5 columns if any one of them contains the word - delete the entire row?pls see attach file.
hope you can make something out of it.
thanks..
- before testing - make a backup copy of your work...
