View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default verify cell if is the same

moving diagonally across the spreadsheet will exhaust the cells to check
when you reach the 256th row.

Maybe you could state exactly what you want to delete and what the actual
conditions to be checked are.

--
Regards,
Tom Ogilvy

"benny " wrote in message
...
I have 2500 row, i want to delete every second row
Except I have to verify if the cell ("A1") of the first row is
identical to the cell ("B1") of the second row.
If the cell ("B1") is identical of ("A1") delete the second row
otherwise don't delete.
Pass to the third row check the cel ("C1") if is identical to ("D1")
delete the the fourth.
Until we dont we pass all the row.

Thank's
Benoit


---
Message posted from http://www.ExcelForum.com/