Macro to Hide Rows

[mkoski]

Can someone help me write a macro that will hide empty rows? As you can see in the picture below, I am working on a spreadsheet to keep score for a fishing tournament. I would like a macro that will hide empty rows from cells A16 through R16, but not hide data in cells S2:U12.

[TMS]

Your request doesn't make sense:

I would like a macro that will hide empty rows from cells A16 through R16, but not hide data in cells S2:U12.

You can hide entire rows or entire columns, but you can't hide parts of the rows or columns. And cells A16 through R16 is one row, row 16. S2:U12 is a range/block of cells.

[OfficeNewb]

Highlight the range of data that contains the empty rows and run the macro below.

Sub HideRows()
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Hidden = True
End Sub