--- now my problem is that I want code to always check the value of tex
in the field C2 and then go on to the next value D2 , E2 etc ~ Do
need to set another loop or somehow select the range ?



Range (“B2”).Select

Do while IsEmpty(ActiveCell.offset(0,1)) = False

If Mid(C2,23,15) = “Calendar Spread” then



ActiveCell.Rows(“2:2”).EntireRow.Select

Selection.Delete

ActiveCell.Offset(0,6).Select



Else



ActiveCell.Offset(1,0).Select



End if



Loo

--
Message posted from http://www.ExcelForum.com