Need Help with Deleting Duplicate rows

[japorms]

Hi Guys,

I hope someone can help me. I need a macro to delete a duplicate row.

The macro will search in Column A and look for duplicate Row. It then
needs to delete one of the duplicate row base on its search in Column
A.

Thanks in advance. I know that this might be easy for some of you
guys, but I've looking all over for a comprehensive macro ebook and I
can't find one. I'm having a hardtime studying the syntax for this.

Thanks again

 

[Niek Otten]

http://www.cpearson.com/excel/deleting.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi Guys,
|
| I hope someone can help me. I need a macro to delete a duplicate row.
|
| The macro will search in Column A and look for duplicate Row. It then
| needs to delete one of the duplicate row base on its search in Column
| A.
|
| Thanks in advance. I know that this might be easy for some of you
| guys, but I've looking all over for a comprehensive macro ebook and I
| can't find one. I'm having a hardtime studying the syntax for this.
|
| Thanks again
|
|
| --
| japorms
| ------------------------------------------------------------------------
| japorms's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6544
| View this thread: http://www.excelforum.com/showthread.php?threadid=559404
|