YellowLabPro
10-27-2006, 12:33 PM
Help changing this section of code:
End With
For r = 2 To LRow2
If Cells(r, "C").Value > 998 Then Cells(r, "A").Value = ""
Next r
End Sub
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
End With
For r = 2 To LRow2
If Cells(r, "C").Value > 998 Then Cells(r, "A").Value = ""
Next r
End Sub
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