For RockroadRow = 1 To Defragglerow
If Cells(RockroadRow, "T").Text Like "TACO*" And _
Cells(RockroadRow, "BT").Text Like "*Blank*" Then

Cells(RockroadRow, "F") = "SOFT TACO"
End If
Next RockroadRow


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=159775

Microsoft Office Help