[jjst34]

Hi,,
I am trying to write a line of code to do the following. Search in entire column A:A and look for ER600L and if it finds it to delete that entire row along w/ the next 8 rows. So far all I can do is make it highlight the row if it is the active cell w/ this code..

Sub processcells()
If ActiveCell = "ER600L" Then ActiveCell.EntireRow.Select
End Sub

It obviously needs some work and I can't get much further just yet... Thanks for any help!