Loop Excel and remove rows

Hello,

I am looping in excel, and when a certain value is hit i need to remove that row and continue looping.

Does anybody have a way of doing this?

When you find a value that meets your criteria, Right Click the Row and select the Modify → Remove → Rows Step.  Note that your Excel variable must not be set as a Global Variable.  If your set your Excel Variable as a Global Variable you will get the "Error from the Remove Rows action.  This steep is not allows on a global variable that is iterated over" Message.

There are other strategies you can use if your spreadsheet must be set to Global.