EXCEL or VBA: Hide row based on cell value?

[wageslave101]

If an IF statement returns a FALSE can the entire ROW be hidden?

=IF($C$49="book1.xls", C63, FALSE)

WageSlave101

 

[jindon]

What is the column houses that formula?

 

[wageslave101]

That formula is in C10, so if the result is FALSE I'd like to hide all of ROW 10... if that's possible

 

[jindon]

Code to the sheet module

Private Sub Worksheet_Calculate()
With Range("c10")
     .EntireRow.Hidden = (.Value = False)
End With
End Sub

Edited: code

 

[wageslave101]

That worked amazingly for such a small code bit thank you very much.

Is it possible to apply this to a range? For example if I want to run this for rows c10:c25?

WageSlave101

 

[jindon]

try

Private Sub Worksheet_Calculate()
With Range("c10:c25")
     .EntireRow.Hidden = False
     On Error Resume Next
     .SpecialCells(xlFormulas,4).EntireRow.Hidden = True
End With
End Sub

 

[Macropod]

or perhaps:

Private Sub Worksheet_Calculate()
Dim i As Integer
For i = 10 To 25
    With Cells(i, 3)
        .EntireRow.Hidden = (.Value = False)
    End With
Next i
End Sub

Cheers

 

[wageslave101]

Awesome Thank you, thank you, thank you

Awed again,

Thanks Jindon!

 

[wageslave101]

Thanks Macropod