Private Sub ML_CommandButton_Click() Dim RowRange As Range Dim RowCnt As Integer Dim r As Integer RowCnt = 0 For r = 0 To ListBox_Ln.ListCount - 1 If ListBox_Ln.Selected(r) Then RowCnt = RowCnt + 1 If RowCnt = 1 Then Set RowRange = ActiveSheet.UsedRange.Rows(r + 1) Else Set RowRange = Union(RowRange, ActiveSheet.UsedRange.Rows(r + 1)) End If End If Next r If Not RowRange Is Nothing Then RowRange.Select Unload Me LastRow = ActiveSheet.UsedRange.Row - 1 + ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For ri = LastRow To 1 Step -1 If Application.CountA(Rows(ri)) = 0 Then Rows(ri).Delete Next riEnd Sub
If ListBox_Ln.Selected(r) =False Then
Private Sub ML_CommandButton_Click() Dim RowRange As Range Dim RowCnt As Integer Dim r As Integer RowCnt = 0 For r = 0 To ListBox_Ln.ListCount - 1 If ListBox_Ln.Selected(r) = False Then RowCnt = RowCnt + 1 If RowCnt = 1 Then Set RowRange = ActiveSheet.UsedRange.Rows(r + 1) Else Set RowRange = Union(RowRange, ActiveSheet.UsedRange.Rows(r + 1)) End If End If Next r RowRange.Delete Unload MeEnd Sub