Hiding blank rows in amongst various worksheets

[James_SF]

Hi All
I have a number of worksheets in a workbook
The object that I am attempting to do is to start at sheet #5, find the blank row 7 through row 49 and hide them.
I was thinking of using the ctrl down arrow after starting at row 6, then control down, add 1, then the rows from there to 49, hide. then go to the next sheet.
Has anyone done this?
Here is what I came up with, I do not think that it's efficient

Please Login or Register  to view this content.

thanks
James

[YasserKhalil]

May be

Please Login or Register  to view this content.