Blank Lines

[Cozmo35]

I have a report that has everyother line blank. I want to delete the blank ones. I attempted to filter it and deselect "blank" but it dosen't work. Any ideas on how I can achieve this?

 

[Cozmo35]

I just had to re-run the report with diffrent options

 

[jbeaucaire]

This oneliner macro may do it for you:

Sub DeleteBlanks()

Range("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete xlShiftUp

End Sub

 

[BrucePorter]

Had the same problem until I found this useful tip from ExcelIsFun on YouTube.

Select all data in one of the columns.
Press F5 (Go To)
Click "Special.." and choose "Blanks" from the options.

This will select all blank cells in the selected data range.

Finally right click one of the highlighted cells and choose "Delete..." and then "Entire row"

 

[Cozmo35]

Thanks Bruce! That worked GREAT!