Hide Rows based on cell values

Hi All,

I think i am making this problem complicated and Im pulling my hair out.

I have two values in cells:

A1 = 9
A2 = 15

I am trying to then get excel to hide rows based on these values but I cant get it to work..

Ive tried:

Please Login or Register  to view this content.

But this will not compile "Expected: list seperator or )".

I also want to then set the printarea to "A" var1: "D" var2 (ie. A9:D15 in this case.)

Im stuck can someone point me in the right direction please?

Thanks.

Try

Please Login or Register  to view this content.

or more simple

Please Login or Register  to view this content.