Select a column and F5SpecialBlanksOK

EditDeleteEntire Rows.


Gord Dibben MS Excel MVP

On Mon, 14 Aug 2006 12:17:22 -0700, "bob sacco" wrote:

I'm trying to remove duplicate email addresses from two seperate email
lists.

I figured out how to get the formula for finding the dups:
http://support.microsoft.com/kb/213367/en-us

But, now I'm trying to figure out how to remove the empty rows I have in my
long columns.

If I could find a formula or macro it would save me a TON of time because I
wouldn't have to go through 60000 rows and remove them manually...

THere MUST be an easier way!

help...Please!