Select then remove duplicates
Posted on 2014-11-27
can an Expert assist me with this, I am sure it is simple but obviously not for me.
I am using the below code to select the current range:
I then want to remove all duplicates from column B within that range [without using a named range like
ActiveSheet.Range("$A$98:$AB$103").RemoveDuplicates Columns:=2, Header:= _
and then I want to sort on column B
Row 98 is the header row for the Range and the number of rows below 98 will vary every time we run the report.