Hide Rows based on cell values

**Chinny123** · 08-23-2011, 07:50 AM

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.

**WinteE** · 08-23-2011, 08:09 AM

Try

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

or more simple

activesheet.rows("A1:A2").hidden = True

**Chinny123** · 08-23-2011, 08:45 AM

Thanks for the nudge in the right direction.

Var1 = Range("A1").Value
Var2 = Range("A2").Value

If ActiveSheet.Rows(Var1 & ":" & Var1).Hidden = True Then
    ActiveSheet.Rows(Var1 & ":" & Var2).Hidden = False
Else
    ActiveSheet.Rows(Var1 & ":" & Var2).Hidden = True
End If

Works a charm for the hiding and

PrintRange = "A" & Var3 & ":" & "D" & Var2
    ActiveSheet.PageSetup.PrintArea = PrintRange

for setting the print range.

Thanks!

Hide Rows based on cell values

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Hide Rows based on cell values

Re: Hide Rows based on cell values

Re: Hide Rows based on cell values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions