Hi

Can someone help me to have macros that’s I wanted to deleted the duplicate Row base the value at column A2 to down, which is numbering .

Your help I high appreciated

Please check if the following links helps:

Checking Duplicate values and delete rows

http://vbadud.blogspot.com/2007/08/d...excel-vba.html

http://vbadud.blogspot.com/2008/07/r...eet-using.html


Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi, All

I have copy the code and modify as below, seem it work but, can't stop when the cell is empty.?

can u help which part's was marking wrong,

Thanks


Range("A1").Select
Do Until IsEmpty(ActiveCell)
Do While ActiveCell = ActiveCell.Offset(1, 0)
ActiveCell.EntireRow.Delete
Loop
ActiveCell.Offset(1, 0).Select
Loop
End Sub