Private Sub CommandButton2_Click()
yy = ListView1.SelectedItem
For I = Range("a65536").End(xlUp).Row To 1 Step -1
If Cells(I, 1) = yy Then
Rows(I).Delete
End If
Next I
End Sub
改为
Private Sub CommandButton2_Click()
yy = ListView1.SelectedItem
For I = Range("a65536").End(xlUp).Row To 1 Step -1
If Cells(I, 1) = yy Then
Range(Cells(I, 1), Cells(I, 4)).Delete Shift:=xlUp
End If
Next I
End Sub
Private Sub CommandButton2_Click()
yy = ListView1.SelectedItem
For I = Range("a65536").End(xlUp).Row To 1 Step -1
If Cells(I, 1) = yy Then
Rows(I).Delete
End If
Next I
End Sub
改为
Private Sub CommandButton2_Click()
yy = ListView1.SelectedItem
For I = Range("a65536").End(xlUp).Row To 1 Step -1
If Cells(I, 1) = yy Then
Range(Cells(I, 1), Cells(I, 4)).Delete Shift:=xlUp
End If
Next I
End Sub