Auto unHide Rows

[Squashua]

Starting off, I know JUNK about VBAs and need a little help. Hopefully I can explain this correctly:

I need to unhide 2 rows at a time starting with rows 28 and 29 IF cell N28:O28 > 0. I need this to be for rows 30 and 31 IF cell N30:O30 > 0, rows 32 and 33 IF cell N32:O32 > 0, rows 34 and 35 IF cell N34:O34 > 0, rows 36 and 37 IF cell N36:O36 > 0, rows 38 and 39 IF cell N38:O38 > 0, rows 40 and 41 IF cell N40:O40 > 0.

There is currently a formula in each of the selected cells that is why I was going for greater than zero. Let me know if you need anything other information. I have seen samples all over and they just do not make sense to me.

Thanks in advance! ^_^

[nathansav]

Record a macro of you hiding them, this will give you an insight into what the VBA is, that is all you'll get back from someone, the same code.

Macros are a great way of learning, especially for tasks like this.