Un/Hide Rows base on cell change for two different cells Un/Hiding different parts of the sheet independently.

[raulmino]

I have a very simple code that works very well to Un/Hide rows when change the cell value of S55. BUT I need a code but works exactly the same for two portions of my sheet independently.

I mean changing the first cell un/hide some rows at the beggining and on the other side changing another cell at the end of the sheet un/hide others rows differents of the one at the beggining.


here is the code.


Private Sub Worksheet_Change(ByVal Target As Range)
Dim HideRows As Range, ViewRows As Range

If Intersect([s55], Target) Is Nothing Then Exit Sub

Select Case [s55].Value
Case Is = 0
Set HideRows = Rows("60:298")
Set ViewRows = Nothing

End Select
On Error Resume Next
HideRows.Hidden = True
ViewRows.Hidden = False
End Sub

Thanks a lot for orientation!

 

[DanteAmor]

Hi and welcome to MrExcel.

How about,
Change cell S55 to 0 to hide rows 60:298.
Change cell T55 to 0 to hide rows 300:598.
Change to 1 to unhide rows.

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Intersect(Target, Range("S55, T55")) Is Nothing Then
    Rows("60:298").Hidden = [S55] = 0
    Rows("300:598").Hidden = [T55] = 0
  End If
End Sub

 

[Macropod]

Cross-posted at:

Un/Hide Rows base on cell change for two different cells Un/Hiding different parts of the sheet independently.

I have a very simple code that works very well to Un/Hide rows when change the cell value of S55. BUT I need a code but works exactly the same for two portions of my sheet independently. I mean changing the first cell un/hide some rows at the beggining and on the other side changing another...

chandoo.org

Un/Hide Rows base on cell change for two different cells Un/Hiding different parts of the

I have a very simple code that works very well to Un/Hide rows when change the cell value of S55. BUT I need a code but works exactly the same for two portions of my sheet independently. I mean changing the first cell un/hide some rows at the beggining and on the other side changing another...

www.excelforum.com

Un/Hide Rows base on cell change for two different cells Un/Hiding different parts of

I have a very simple code that works very well to Un/Hide rows when change the cell value of S55. BUT I need a code but works exactly the same for two portions of my sheet independently. I mean changing the first cell un/hide some rows at the beggining and on the other side changing another...

www.excelguru.ca

Un/Hide Rows base on cell change of two different cells Un/Hiding different parts of the sheet independently

I have a very simple code that works very well to Un/Hide rows when change the cell value of S55. BUT I need a code but works exactly the same for two portions of my sheet independently. I mean ch...

stackoverflow.com

Please read Mr Excel's policy on Cross-Posting in rule 13: Message Board Rules

 

[raulmino]

Sorry I am new posting a question but i really appreciated your help.

Have a great day!!!