PDA

View Full Version : delete row if column f is blank



ssinghal
04-11-2008, 11:09 AM
I have a spreadsheet with 5000 rows. I want to delete each row that does not have a value in Column F.

I appreciate the help.

MikeO
04-11-2008, 11:14 AM
ActiveSheet.Range("F1:F5000").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

mdmackillop
04-11-2008, 11:15 AM
Sub DelBlanks()
ActiveSheet.Range("F:F").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub