VB clearing whole row - only need it to clear two columns please assist

[jousley]

Hello, I am using the following snipped to match values and clear the row in "main". The problem is: I don't want the whole row cleared when a match is found in column E of main. What I want is for only the cells in column E & F to be cleared, not the whole row. Can someone please show me the appropriate tweak?

Please Login or Register  to view this content.

thanks in advance
J

[AlphaFrog]

Add the bit it red.

.Rows(i).Range("E1:F1").ClearContents

[Ed_Collins]

How about...

Please Login or Register  to view this content.

[jousley]

Thank you AlphaFrog! Worked! Thanks Ed_Collins! That one does the trick as well.

J