You probably have to qualify the range reference with the worksheet
index number or proper name:

Sub DeleteRows()

If WorksheetFunction.Sum(Worksheets(1).Range("C1:O1") ) = 0 Then
Worksheets(1).Range("C1").EntireRow.Delete
End If

End Sub

Change "Worksheets(1)" to the name or index number of your exact
sheet, for example if you have a worksheet named "Tables" and it was
the third tab in your sheet, you could refer to it by
Worksheets("Tables") or Worksheets(3).

HTH,
JP


On Mar 14, 5:12*pm, Caligirl
wrote:
this sounds like what I need. *When I run it I get this error message:
Unable to get the Sum Property of the Worksheet Function Class

Any ideas?