Macro to HIDE blank rows
Sub row_hide()
Dim rng As Integer, i As Integer
rng = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To rng
Cells(i, "A").Select
x = Application.WorksheetFunction.Count(ActiveCell.Ent ireRow)
If x = 0 Then ActiveCell.EntireRow.Hidden = True
Next i
End Sub
On Jun 5, 6:08*pm, JForsyth
wrote:
I have seen a couple of threads on how to create a macro to DELETE blank rows
but this is not what I'm looking for. I need to be able to simply HIDE the
blank rows. Does anyone know how to do this?
|