Hide Blank Rows in Active Worksheet

Hello All

I have a workbook with sheets that have a "Hide Blank Rows" Button, the macro that
runs it works fine for the sheet that it is on, however when I duplicate the sheet it
won't work anymore, so I need it to reference to the "ActiveSheet" instead of the
named sheet. I tried messing with it, but seem not to be able to get it to work.

Please Login or Register  to view this content.

The "Apr 30 - May 5" is the sheet name, but I need it to refer to the ActiveSheet?

Any help, would be very much appreciated. Thanks

Try,

Please Login or Register  to view this content.

Thank you so much, that did the trick. I've been trying to add ActiveSheet into the code
and that did not work. Been messing with this for hours now.

Again thank you very much.