Automate deleting duplicate rows

[Guest]

In Excel 2000, is there a way to write a macro or something to automate the
deletion of duplicate rows in the spreadsheet? I'm new to visual basic, and
any help would be much appreciated. I delete dup rows on a weekly basis and
I'd like to try to save some time and be more accurate. Thank you for your
time...

 

[Bob Phillips]

Data>Filter>Advanced Filter

it has a unique rows facility.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I do not see the unique rows facility...

Data>Filter>Advanced Filter

it has a unique rows facility.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Okay... I found it. I've never used advanced filter, so I will play around
with it. Thanks