Hi David,

I`ve used the advanced filter (unique) option.
But the code is not working

Your problem may reside in the fact that, in order to extract the filter
data to another sheet, it is necessary to set up the filter operation from
the destination sheet.

See the section: Extract Data to Another Worksheet

on Debra Dalgleish's Advanced Filter page

http://www.contextures.com/xladvfilter01.html

---
Regards,
Norman



"david shapiro" wrote in message
...
I`d like to use this code to remove all duplicate rows in a dataset and
then to run it in a number of worksheets with datasets of varying size
(rows and columns) where the range is changing. I`ve used the advanced
filter (unique) option. But the code is not working. Anyone know the
right code for this?

sheets ("sheet1").select
range("A1").CurrentRegion.select.advancedfilter Action:=xlfiltercopy,_
copytorange:=range(???), Unique:=true

David Shapiro



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!