how to delete dublicates rom selected column

[katya_p]

Hello,

I am sorry if my question is too easy, but it is my third day with vba and the job needs to be done..

I have a column and i need to delete dublicates from it, each time it would be a different column.
I know a bout the button "Del dublicates" but my macros is doing other stuff and i want to delete dublicates at the end of the procedure.

I worked with Selection and I put output to the column next to it. Now I need to work with it. My attempt:

...some code before
' Reselecting the range
Selection.Offset(0, 1).Select
' Checking for dublicates in the column
ActiveSheet.Selection.RemoveDuplicates Columns:=1, Header:=xlNo Doesn't work


Thank you for ur help!
Katya

[john55]

try this, it deletes the duplicates from column f, please change for yr needs!

Please Login or Register  to view this content.