MrExcel Publishing
Your One Stop for Excel Tips & Solutions

REMOVING duplicate rows


Posted by Conor on November 01, 2001 11:57 PM

good day everybody,

anyone know how to using visual basic in excel to remove duplicate rows from a ss with approx 10 columns??

any help appreciated..


Posted by Juan Pablo on November 02, 2001 4:48 AM

How about using Advanced Autofilter and copy results somewhere else, checking UNIQUE RESULTS ?

Juan Pablo