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!