Hi,

I need to find the values “ADD” and “SUB” in a column B and delete all the rows in-between the words “ADD” and “SUB”.
There might be more than one “ADD” or “SUB”.

Looping should be only one time.
Can this be done using macro.. if so help me out in this…
There might be around 2000 rows in a sheet…

Immediate help would be highly appreciated.

-Sindhuja