Looping an if statement with row number variable

**Benisato** · 10-06-2011, 03:09 PM

Hello all, I have a simple if statement that looks like this:

Please Login or Register  to view this content.

It basically compares 2 cells to each other (A5 and K22), and if they match, and the other cell in the same row is not blank (B22), then it unhides the entire row.

I need to do that for each row from 22 to 218. Obviously I don't want to rewrite this if statement 200 times, but I am not sure how to make a loop that does it automatically.

I'm sure its fairly simple, but I am really not good with loops. Any assistance with this would be greatly appreciated

Chris

**Whizbang** · 10-06-2011, 03:28 PM

Please Login or Register  to view this content.

**tlafferty** · 10-06-2011, 03:31 PM

Sounds like you want to hide rows that are separated by 17 rows if they meet your criteria, beginning at row 5, and ending at row 201 (17 rows down from that would be row 218). If that's the case, try:

Please Login or Register  to view this content.

**tlafferty** · 10-06-2011, 08:13 PM

Explanatory note to previously posted code...What the code "should" do (untested) is check to see if A5 and K22 match, and that B22 is not 0. It then compares A6, K23 and B23| A7, K24 and B24 etc.