John - thank you for your quick reply. For some reason it's still not quite working.

JBeaucaire - In real time I want row B29:B47 to be hidden. Once a value (number or text) is entered in B28 I want to show row B29. Subsequently once a value has been entered in B29 I want to show row B30, and so forth. This should all operate automatically (e.g., Private Sub Worksheet_Change(ByVal Target As Range)) without manually running a macro. The goal is to hide extra rows to make the worksheet more manageable and then unhide them once needed. Any suggestions?