Move row if matches criteria

I am using the following code in "Worksheet Change" to see if a column contains the word "Deleted" - if it does, it cuts the row and pastes it on the first blank row on a different worksheet, then it removes the row from the original sheet so that I dont have any gaps in my data. The code works great except if the word is on the very last row, then it only moves the row up to the column and leaves behind all the data that falls after it.

How many rows and columns are not static, the only thing that is certain is that the word "Deleted" will be in this column all the time.

Any idea how I can fix this? Thank you!

Please Login or Register  to view this content.

The code works great except if the word is on the very last row, then it only moves the row up to the column and leaves behind all the data that falls after it.

Can you explain what you mean by this? If the word is on the very last row, how can there be "data that falls after it"?
And how is the row moved up the column?

I ran your macro and it seems to work OK. But then, I don't have your data.

works fine for me in xl 2010.

Rows are moved and cleared completely. No leftover data, regardless of last row or not.

Have you tried stepping through your code, maybe with a few Select statements thrown in to see what's happening?