unhide rows within a certain range automatically

[bjornesto]

I have made a report and I want to hide some rows inside that report on several locations. It are empty rows but in vba there are some codes already programmed. The idea is that they need to unhide automatically when the previous row is filled in with data.

So if row 52 is filled in automatically row 53 will need to appear

like
row 53 till 69
row 77 till 111
row 173 till 177
row 200 till 203
row 212 till 218

Is there any way how to do that?

 

[sergioMabres]

You could program the event "Worksheet_Change" receive the Target and if it is the rows that you care for you could show other rows
Worksheet_Change is called when data is entered