macro to delete rows if value 1 is in two differenet cells

[Ipinho100]

Hi

Could someone help me with the following problem. If value 1 does not appear twice in the same row between rows 2 and 21 i want to delete all those rows. If it does appear then nothing happens. Then the same thing in rows 22 to 41 and 42 to 61 and so on....

Please see the file.

[mahaveersomani]

i understand that you want for rows 2 to 21 but what you want for rows22 to 41 and 42 to 61?

[nilem]

maybe so

Please Login or Register  to view this content.

[Ipinho100]

Thank you!

[Ipinho100]

I still have a problem with the macro. Now it deletes all the rows where is not value 1 in the cells next to each other. But what i want is that if value 1 appears twice in any of rows number 2 to 21 i want that all those rows (2 to 21) stay untouched. If value 1 does not appear twice in any of the rows 2 to 21 then i want all those rows (2 to 21) be deleted. Then the same thing in rows 22 to 41 and 42 to 61........and so on...
I hope i made the problem easier to understand.

[nilem]

then try it

Please Login or Register  to view this content.