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:

var1 = range("a1").value
var2 = range("a2").value
activesheet.rows(var1 : var2).hidden = True

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.