View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Vass[_5_] Vass[_5_] is offline
external usenet poster
 
Posts: 4
Default delete row if duplicate


"Don Guillett" wrote in message
...
A macro that looks at col F and col H
sub deldups()
for i = cells(rows.count, "f").end(xlup).row to 1 step -1
if cells(i,"f")=cells(i,"h") then rows(i).delete
next i
end sub
--
Don Guillett


cheers Don
--
V