Removes Duplicates Except Blanks macro

So basically, it removes duplicates as normal, except it ignores blank cells completely no matter how many there are.

Since two blank cells are equal (Both Nil) , hence duplicates

Is that a solution or...?

Yes, it is- just to confirm your thoughts.

But when i run the code it does not ignore blank cells?

You said

"except it ignores blank cells completely".

I may be wrong, but my understanding is that if two rows are blank (I mean REAL empty), they are treated as equal, hence duplciates. This is just my opinion.

That is correct. However I want the code to ignore that and only remove duplicates in cells that are not blank. So it may possibly be a loop code that if cell x <> '''' then compare cell x against other cellsin that range and delete duplicates

Not quite Mike. If there are 2 or more instances of the same cell then I want to leave the first instance of the word. Also, my list of names can be any number of rows long, so it could be 18 or more depending.

Book1.xlsm

Attached is what I have and what I want it to look life after macro runs. Bear in mind the list of names can be any length but no more than 38 rows.

Works fine Mike.
I just did this too which works

Please Login or Register  to view this content.

Works fine Mike.
I just did this too which works

Please Login or Register  to view this content.