Related:
- Excel blank row deletion
- Excel date format dd.mm.yyyy - Guide
- Saints row 2 cheats - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
Go to Tool > Macro > Visual Basic Editor
Type in the following into the page you want to delete the blank line from
-------------------------------------------------------------------------------------------------------------
Sub DeleteHiddenRows()
Dim iRow As Long
With Application
.Calculation = xlCalculationManual
.EnableEvents = False
.ScreenUpdating = False
With ActiveSheet.UsedRange
For iRow = .Row + .Rows.Count - 1 To .Row Step -1
If Rows(iRow).Hidden Then Rows(iRow).Delete
Next iRow
End With
.Calculation = xlCalculationAutomatic
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub
-------------------------------------------------------------------------------------------------------------
Thats it :o)
Type in the following into the page you want to delete the blank line from
-------------------------------------------------------------------------------------------------------------
Sub DeleteHiddenRows()
Dim iRow As Long
With Application
.Calculation = xlCalculationManual
.EnableEvents = False
.ScreenUpdating = False
With ActiveSheet.UsedRange
For iRow = .Row + .Rows.Count - 1 To .Row Step -1
If Rows(iRow).Hidden Then Rows(iRow).Delete
Next iRow
End With
.Calculation = xlCalculationAutomatic
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub
-------------------------------------------------------------------------------------------------------------
Thats it :o)
