Hiding rows not containing any data

Dear friends,


I have simple requirement to hide (or suppress) the rows that do not contain any data. In the attached screenshot, I want to hide the rows 2,6:9 (highlighted in green) as these rows have data/value.

I want rows 3:5 not be be hidden (highlighted in yellow) as it has data/value in these rows.

Kindly advice on the code.

Screen Shot Excel Forum.png



Thanks,
Rahul