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
|