Private Sub OKButton_Click()
Dim i As Long, j As Long
Dim ws As Worksheet
Dim cells As Range
j = 0
For i = 0 To Me.Option2ListBox.ListCount - 1
If Me.Option2ListBox.Selected(i) = True Then
With worksheets("Schedules")
Set lrow = .cells(Rows.Count,"H").End(xlUp).row
set r = .Range("H1").Resize(lrow,1)
End With
if application.Countif(r,Me.Option2Listbox.List(i)) > 0 then
For k = lrow to 1 step -1
set rng = worksheets("Schedules").Cells(k,"H")
If rng = Me.Option2ListBox.List(i) Then
rng.EntireRow.Delete
End If
Next
End if
j = j + 1
End If
Next i
Unload ImportingSchedules
End Sub

Signature
Regards,
Tom Ogilvy
> Option2ListBox populates with the items contained in Col H of the 'Schedules'
> tab; the user can then select 1 or more of these items. For each selected
[quoted text clipped - 28 lines]
> Unload ImportingSchedules
> End Sub
Paige - 23 Aug 2007 17:38 GMT
Thanks, Tom. However, am getting a 'Type Mismatch' error on the 'Set lrow
=...' line of code. What would that be due to?
> Private Sub OKButton_Click()
> Dim i As Long, j As Long
[quoted text clipped - 55 lines]
> > Unload ImportingSchedules
> > End Sub
Dave Peterson - 23 Aug 2007 18:52 GMT
Try removing the word "Set" from this line:
Set lrow = .cells(Rows.Count,"H").End(xlUp).row
so it's just:
lrow = .cells(Rows.Count,"H").End(xlUp).row
> Thanks, Tom. However, am getting a 'Type Mismatch' error on the 'Set lrow
> =...' line of code. What would that be due to?
[quoted text clipped - 62 lines]
> > > Unload ImportingSchedules
> > > End Sub

Signature
Dave Peterson
Paige - 23 Aug 2007 17:58 GMT
Did some digging re the type mismatch; was due to the fact that I hadn't
referenced the correct VBA extensibility library. So now don't get the error
message; however, it does not delete any applicable rows.
> Private Sub OKButton_Click()
> Dim i As Long, j As Long
[quoted text clipped - 55 lines]
> > Unload ImportingSchedules
> > End Sub
Tom Ogilvy - 23 Aug 2007 21:04 GMT
as Dave said, remove the SET statement from that line. It is residue left
over from editing your code.

Signature
Regards,
Tom Ogilvy
> Did some digging re the type mismatch; was due to the fact that I hadn't
> referenced the correct VBA extensibility library. So now don't get the error
[quoted text clipped - 59 lines]
> > > Unload ImportingSchedules
> > > End Sub
Paige - 23 Aug 2007 21:38 GMT
Thanks, guys!!!! Works great now. Really really appreciate the help.
> as Dave said, remove the SET statement from that line. It is residue left
> over from editing your code.
[quoted text clipped - 62 lines]
> > > > Unload ImportingSchedules
> > > > End Sub