Hide/Unhide Rows

I found some Useful code, but i need it to do more.

[code]
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B4").Value = 0 Then
Rows("14:16").EntireRow.Hidden = True
Else
Rows("14:16").EntireRow.Hidden = False
End If
End Sub
[code]

if i add rows above this code it adds the next row in the range to the hide list, but never unhides the additional row.

Needed:

I want to hide certain rows that do not need to be seen until a value is entered elsewhere.
I want to apply this to several sets of rows, even if i need multiple macros.

The rows that i want to hide will be located below the main body of the report, so row numbers will increase constantly however;
No rows will be added to the hidden selection, only values will change.

One way to do this is to create a named range in the row(s) you want to hide or unhide. Name a cell (Formulas/Define Name), e.g. "MyName1". The code for hiding the row of that cell is:

Please Login or Register  to view this content.

Hi this works for me

Please Login or Register  to view this content.

Toonies,
I tried your code, but when i inserted rows above it the effected rows did not move lower in the order.

This is based on the OP, feel free to change it around.

Please Login or Register  to view this content.

RHCPgergo,

Thank you! I used 2 named ranges instead of a cell value!