View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JHopper JHopper is offline
external usenet poster
 
Posts: 5
Default If Column T contains then

Very nice. Thank you for the extra help.

"joel" wrote:


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

.