Hide Cells

[lightbulb]

Is there a macro or formula I can use to hide certain rows if certain cells
say "OK"?

For example, Hide any Rows between 78 and 131 when column T in those rows
equals "OK", all other rows in that range will remain visible.

Thanks!

 

[Jarek Kujawa]

Sub cus()

For i = 78 To 131
If Range("C" & i) = "OK" Then
Range("C" & i).Rows.EntireRow.Hidden = True
End If
Next i

End Sub

 

[lightbulb]

I selected view code by right clicking on the tab name, and pasted in the
code below, but nothing happened...it's been awhile since I've worked with
Macros, is there something else I have to do?

 

[Jarek Kujawa]

press ALT+F11 to get to VBA
then Insert->Module
paste the code
click Run