View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
marina madeleine marina madeleine is offline
external usenet poster
 
Posts: 22
Default Deleting Duplicate Rows

I happened to see this thread on deleting duplicate rows from a while
back (for a worksheet where the rows have the same values in all
columns) and have tried out the advanced filter for unique rows.

While I am able to do the advanced filter manually, is there any code
you could suggest that would do the same which would delete all the
duplicate rows in the excel worksheet?

Thanks.

Marina Madeleine



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