Greetings, I have a data file of 1000 rows, The height of the rows is 25. The problem is the blank rows are also 25. Can you tell me how I can reduce the ROW HEIGHT on the BLANK rows only? Is this even possible?
record a macro then stop the recording, copy paste this code instead of the recorded macro
Dim i As Long
For i = 1 To 1000
If IsEmpty(Cells(i, 1).Value) Then
Cells(i, 1).RowHeight = 5
You can change the row height from 5 to any value
You can iterate between 1 to 1000 or you can change it.