Delete entire row when cell says delete

Hi folks,

i need some code that delete the entire row when a cell says deletein it:

here's what i have so far:

Please Login or Register  to view this content.

i'm not sure why its not working but im sure you'll tell me why?

cheers for reading my thread!

If the first cell isn't delete then the loop will stop

See link for how to use loops

http://www.exceltip.com/st/Using_Loo...Excel/628.html

I would try

Please Login or Register  to view this content.

HTH

VBA Noob

yeah there are lots of rows that need deleting, the reason my code says the above is because i have sorted the data so that the "delete" are all at the top.

Here is my entire code for you to see,

i changed it at the bottom so that the If criteria is inside the loop, although its not working, please feel free to modify this code to increase the speed and make it easier.

Please Login or Register  to view this content.

Cheers for the help but that didn't work, it deleted all of the data!!

not to worry i will do it maunally.

unless you know how to select all the rows when a cell in column E has Delete in in?

I can't buddy,

its way too big to even zipp down not to worry ill crack it using trial and error!!

thanks anyway buddy!!