Deleting row if the cell in the column is empty

[prima satria]

I sort the data with sort key in column C, and want to delete all empty rows starting from row number 5 automatically using VBA. How to write a code so when the last "fill" row in column C is row number 4 then row number 5 to last will be deleted. And if the last "fill" row in column C
is row number 100 then row number 101 to last will be deleted.

A B C
YEAR WO COST REMARKS
2 2005 25,000 OUTSTANDING
3 2006 3,000 OUTSTANDING
4 2005 100 OUTSTANDING
5 2005 700
6 2007 500

Thx in advance.

 

[VoG]

Try this on a copy of your sheet

Sub Del()
Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

 

[da_vide78]

ha, I had the exact same question the other day! An used the same code which is cool cos it's so fast!

 

[prima satria]

Thx so much, you make my day much brighter ! Problem solved !