Hide Blank Rows

Hi. I'm new to forum. I need a macro that will help me hide rows that have no current data in it. I would like to email someone a portion of sheet so you can see it vs. trying to explain if that is allowed. I have one spreadsheet with several names and each name will have 12 months (12 rows). Each month I go in and filter to the current month and the names that I need and input data but not all names will end up with data for the current month and those are the rows I would love to quickly hide (not delete) at one time for the final report. The rest of my data for the prior months is hiding. Th

I would like to email someone a portion of sheet so you can see it vs. trying to explain if that is allowed.

Do you mean email a forum member the workbook? If so, then no, we prefer that you upload your sample workbook to the forum here.

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.