Run-time error: no cells found. Handling this error?

[OfficeUser]

I get a runtime error using this macro:

Private Sub DeleteRows()
On Error Resume Next
Columns("C:C").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
End Sub

It produces an error if there are no rows to delete. How do I prevent the error from happening? This macro is triggered from within a separate macro like this:

Run "DeleteRows"

Thanks for the help!!

 

[OfficeUser]

With this in mind, I must admit I dont understand why you still get an error, especially bearing in mind that the msgbox showed 0.

Not sure either. I can post the entire code if it still helps you. I don't want to use up anymore of your time though since I have found a solution that works, unless you still think its worth looking at. Again, I appreciate the help.

 

[Fluff]

If the msgbox said 0 when running the Delete Rows from another macro, then there is no need to post the other code, as that is not causing the problem.

 

[OfficeUser]

Got it, thanks.

 

[Fluff]

You're welcome.
Sorry I couldn't be of more help