View Single Post
  #5   Report Post  
Dennis
 
Posts: n/a
Default

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