Not that responding to this guarantees a satisfactory resolution to
your problem, but...

What does "opposite of cell" mean?

Examples of what you want to do would not hurt.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I would like to create in vba the following:

If in column "X" cell equals another cell in the same column
AND
If in column "Y" cell is the opposite of cell in the same column
Then
Delete both rows

thanks in advance and best regards

Nordine