If contents match delete row

[JBowie]

If the contents in Column I is exactly the same as the contents in Column J then I want to delete the entire row; starting in Row 2 and repeating until every row with contents in Column I and J has been checked. Here’s what I have can you help?

Please Login or Register  to view this content.

[Joske920]

Hi JBowie,

I can see you know some vba so im not going to give you the solution
its way more fun to find it yourself in my opinion

keep in mind that you delete a row that means the cells move up but you didnt check that row
the for loop keeps going
try to do it without the for each but with a integer or long so when you delete a row, you go back 1 row because you didnt check that row yet it moved up

i hope im clear enough
Grtz

[JBowie]

I have not yet been able to figure this out on my own. Can someone help me?

[Joske920]

Hi JBowie,

This should do it

Please Login or Register  to view this content.

Grtz

[bakerman2]

When deleting rows you always start at the bottom and work your way up.

Please Login or Register  to view this content.

[daboho]

Please Login or Register  to view this content.

[JBowie]

This works thank you