Simple enough and does what it's supposed to but...
the sheet im working with is >5k lines long and i dont know how to work this out without a loop, so it takes forever to complete.
would be great if someone has an idea how to improve on this.
Sub AdjustEmptyRowHeight()
Dim i As Integer
Dim lRow As Long
lRow = ActiveSheet.UsedRange.rows(ActiveSheet.UsedRange.rows.Count).Row
'Application.ScreenUpdating = False
For i = 1 To lRow Step 1
If WorksheetFunction.CountA(rows(i)) = 0 Then
rows(i).RowHeight = 5
End If
Next i
'Application.ScreenUpdating = True
End Sub
Bookmarks