I need to find a function or macro that deletets lines

[peterdavies]

I need to delete lines from a spreed sheet if the sum of a cell is 0 can any one help?

[IcemanND]

Excel Macro:

'look at the value of the current cell for value of zero.  
'If not on the current cell the use range("A1").value, 
'where A1 is the cell with the value you wish to check

if activecell.value=0 then
'Removes the row from the spreadsheet
	rows("1:1").select
	Selection.Delete Shift;=xlUp
'Deletes only the contents of the cells in the row
	rows("2:2").select
	Selection.ClearContents
end if