deleting identical rows

[Guest]

hi,

Is it possible to delete identical rows in a sheet. (each row has about 10 cells of information: if all cells are identical I want to delete the row) I want to build a macro which does this everytime a user closes the sheet. (so on workbook_beforeclose)

Hope anyway can help me on the way.

Thnks!

Remi
Holland.

 

[Guest]

Great, indeed the advanced filter function is what i`m looking for!

sorry for not dicribing it more clearly.

Thank you all.

Remi.