If I understand correctly, maybe this will help.

Sub MrMac()
[A:A].AutoFilter Field:=1, Criteria1:="Ref#"
Selection.SpecialCells(xlCellTypeVisible).EntireRo w.Delete
End Sub
--
Mike Q.


"Tufail" wrote:

sorry posting again.

ok, maybe there isn't any way that i haven't get any post, ok then any other
way to find out from my selection duplicate then delete those column ?
selection would be A:A

thanks in advance .

"Tufail" wrote:

hi
i want creat a macro that find duplicate data and not allow to download, i
means everyday i am downloading data from web and i am keeping in my
spreadsheet (i'm copying from web then doing paste in my sheet) and now i am
facing problam that duplicate data dowloading again and again, i want find
duplicate by A:A becoz there is Ref# always, my data range is A_col H_col ,
hopefull you got what i want say or what i want to make.

Thanks