Hi,

Im a total novice and did not know where else to turn so here goes. I found this code to hide blank rows and it works but I need it to hide rows on select worksheets in my file.

The worksheets it needs to run on are"SHEET5", "SHEET6", "SHEET7", "SHEET8", "SHEET9", "SHEET10", "SHEET11", "SHEET12" , and "SHEET13".


Sub hideEmptyRows2()


Application.ScreenUpdating = False


For i = 3 To 120
If ActiveSheet.Cells(i, 1) = "" Then
ActiveSheet.Cells(i, 1).EntireRow.Hidden = True
End If
Next i


Application.ScreenUpdating = True


End Sub

Thanks in advance!

Best,
Aidan