Hi,
I have the following code:
There is a For loop that searched down cells in a spreadsheet. When I find a match, I simply want to delete the whole row but am not sure of the code.
Can anyone help?
Chris
I have the following code:
Rich (BB code):
For i = lRowNum To ActiveSheet.UsedRange.Rows.Count - 1
If Cells(i, 1).Value = ComboBox1.Value Then
Delete Whole Row
Exit For
End If
Next i
Can anyone help?
Chris