View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
sreedhar[_10_] sreedhar[_10_] is offline
external usenet poster
 
Posts: 1
Default comparing rows and deletion


hi jim,

i have try changing the code to <=, = ,< but also it is not clearin
any rows even if it true.

i have try for rows

1 0 1 1
0 1 1 0
0 0 0 0
1 0 0 0

but the code is not clearing or deteleting any row.what i want is fo
the above rows it should delete 3rd and 4th row because they ar
lessthan and equal to every cell in 1st row.

2nd row can't be deleted because 2nd cell " 1 "geraterthan the 2nd cel
"0" of 1st row.

so ,plz help me

thanks
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