i am working on a macro which takes values from sheet 1 and paste unique values in sheet2.
I have written code for
this but the problem i am facing is that it generates first value twice.
Dim r As Range, r1 As Range
Set r = Range("H8", "H240")
Set r1 = Range("H8", Range("H8").End(xlDown))
r1.Sort Key1:=r1, Order1:=xlAscending, Header:=xlNo
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This macro works fine but the value at H8 gets repeated twice.
Please help m stuck at this point.
THanks in advance.