Thanx again Bob, works great!!!!!! Man you guys are good, and fast!
Dennis
==================
wrote:
Hi Dennis,
How about this then, no helper cells
Sub test()
Dim rng As Range
Dim iRow As Long
Dim i As Long
Set rng = Selection
For i = 1 To 3
iRow = Application.Match(Application.Small(rng, 1), rng, 0)
Cells(iRow, rng.Column).Delete Shift:=xlUp
Next i
End Sub
|