VBA Macro to enable auto hide of blank rows.

The following VBA Macro code will help you in performing auto-hiding blank rows in a specific worksheet.

Sub hideEmptyRows()

Application.ScreenUpdating = False

For i = 3 To 25 'Include the row numbers

  If ActiveSheet.Cells(i, 1) = "" Then

    ActiveSheet.Cells(i, 1).EntireRow.Hidden = True

End If

Next i

Application.ScreenUpdating = True

End Sub