Hi
simply record a macro while invoking the advanced filter

--
Regards
Frank Kabel
Frankfurt, Germany

"marina madeleine" schrieb im
Newsbeitrag ...
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!