hi jim,

it is working for first row thanks a lot ,

my problem is

after comparing with the first row it should then comparing with 2n
row with all other rows and delete.

after completion of 2nd row it should use 3rd row to compare with al
other rows
and delete.

like this it should follow all the rows till end

my idea for this is after clear any row we have call this marco to fil
up the empty blanks in the excel sheet.

Sub RemoveBlankRows()
Columns("A:A").SpecialCells(xlCellTypeBlanks).Dele te Shift:=xlUp

End Sub

and then agin go for other row comparsion and so on.


plz, help me regarding this

thank u
sre

--
sreedha
-----------------------------------------------------------------------
sreedhar's Profile: http://www.excelforum.com/member.php...fo&userid=2758
View this thread: http://www.excelforum.com/showthread.php?threadid=47453