View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ixtreme Ixtreme is offline
external usenet poster
 
Posts: 61
Default Delete rows with duplicate information

Joel,

Thanks again, but it is still not fast enough. Would it be possible to
do the deleteing only on the selected rows that are displayed after
using criteria in an autofilter?

I have an autofilter with column B displaying the specific weeknumber
of the date in column D. If the user selects for example only to
display week 33, would it be possible to run the Macro
Removed_Duplicates only for the selected rows of week 33?

Thanks for your help!

Mark