code to delete rows

Hi,

I need some code to delete 200 rows after the word STOP is found in column F

Any help greatly appreciated

Kevin

Try this

Please Login or Register  to view this content.

That code is deleting everything with the exception of the first 2 rows
I need to delete 200 rows after the word stop

You said

Originally Posted by Excelski

I need some code to delete 200 rows after the word STOP is found in column F

And the code I posted should do so.

Sorry... I should have be clearer........ when the word stop is found in column F I need to delete the next 200 rows

That's what the code should do.

Upload the workbook.

i am just boarding a flight ill have to come back to this, thanks for looking