Hide Row if ALL cells in Rng are Blank

How's it going, Roy? Thanks for the response.

That didn't seem to do it, but I think there is a better way. In the attached sample, you will notice I have accumulated information for each part number, and for each week. The buttons I have at the top are supposed to make it easier to navigate, but in a spreadsheet with thousands of part numbers, it still looks like a jumble.

What I would like to do is put a button above each date that would hide all rows that don't show an entry, under either of the 3 columns, for THAT date.

For example, if the user clicked the "Show ETA" button, then clicked the "Hide Blank Rows" button above the date "8/15 to 8/21", only the rows containing data for that date would be displayed. The tricky part is, if I've already hidden some of the columns by clicking to "Show ETA", then the range I want to check has changed. I no longer would need to hide rows in which all cells E thru G are blank, I only need to hide the rows in whcih column F are blank.

Am I making any sense? Can this be done, or do I need to look in another direction?

Thanks for the help.

Okay, Roy. I changed that part of the code in the new sample I have attached. But still, when I press the "Hide Blank Rows" button, the only row that gets hidden is row 3.

Beautiful, Roy!

I've attached the sample with the latest script included, in case you want to see what I was trying to accomplish.

Thanks, and have a good one!

Sorry, Roy. I had forgotten to mark the thread as Solved.

Thanks for all your help.