If Greater than formula

[YellowLabPro]

Help changing this section of code:
[VBA]
End With
For r = 2 To LRow2
If Cells(r, "C").Value > 998 Then Cells(r, "A").Value = ""
Next r

End Sub
[/VBA]

This line replaces column "A" w/ "", what I need it to do is replace the entire line w/ "" if the value > 998.

Help please?

Thanks,

YLP

[mvidas]

Yelp!

[vba]' If Cells(r, "C").Value > 998 Then Cells(r, "A").Value = ""
If Cells(r, "C").Value > 998 Then Rows(r).ClearContents[/vba]

Didn't you ask this one before?
Matt

[SamT]

[VBA]

For r = 2 To LRow2
If Cells(r, "C").Value > 998 Then Range(r:r).ClearContents
Next r

[/VBA]