Thread: Advanced Filter vs. Macro for deleting dup rows in sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lexcel lexcel is offline
external usenet poster
  
Posts: 34
Default Advanced Filter vs. Macro for deleting dup rows in sheet
The best is to combine the two:
Filter the sheet, then use a macro to delete the cells that are not
visible.
Maybe the Range property Specialcells(xlVisible) can be of use in this.

Reply With QuoteReply With Quote