Starboy

Only through the use of VBA code.

Option Compare Text
Sub Delete_Stuff()
'using set column
Dim RngCol As Range
Dim i As Range
Set RngCol = Range("B1", Range("B" & Rows.Count). _
End(xlUp).Address)
For Each i In RngCol
If i.Value = "SD" Then _
i.Offset(0, 2).ClearContents
Next i
End Sub


Gord Dibben Excel MVP


On Thu, 21 Jul 2005 07:47:09 -0700, "StarBoy2000"
wrote:

How do I Delete Contents of D2 if B2 = "SD". Then continue through every row
in the file?