Hi,

Am Thu, 10 Mar 2016 17:54:51 GMT schrieb :

But can I define the range to be looked through?
I tried to insert this in the macro, but it did not work.
Range("A6:C48").Select

try it this way:

Sub UniqueValues()
ActiveSheet.Range("A6:C48").Copy Sheets("test").Range("A1")
Sheets("test").UsedRange.RemoveDuplicates Columns:=3, Header:=xlNo
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional