Okay Les, this is what it does
first it calculates where the last row is
it then loops backwards from the last row to row 2 (backwards as it is
deleting rows, and row 2 as it is checking against the previous row)
if the value in column of the current row is the same as the value in column
A of the previous row AND the value in column B is repeated in column D
(Application.CountIf(Columns(4), Cells(i, "D").Value) 1) then it deletes
the current row
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Les Stout" wrote in message
...
Hi Bob, it appears to be working great.... Could you please explain it
to me so that i can understand what it is doing ??
Thanks Bob, you really are a life saver...
Les Stout
*** Sent via Developersdex http://www.developersdex.com ***