Hi all i have just answered a post on another forum and my soultion to their question is posted below what i would like to know is, is this the way to do it or is there a smarter way?
Quote Originally Posted by Another Forum
How do I check this column and if it is blank or has a 0 (zero) entered in it, the row is deleted?
[VBA]
Sub removeblank()
Dim Rng As Range
Dim MyCell
Dim i
i = 1
Set Rng = Range("C9:C119")
For Each MyCell In Rng
If MyCell = Null Or MyCell = 0 Then
MyCell.EntireRow.Delete
End If
i = i + 1
Next
MsgBox "There were " & i & " Rows Deleted!"
End Sub

[/VBA]Regards,
Simon