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..