yr macro will delete ALL cells with errors and formulas that are in
the worksheet

to remove "total board" and "total metal" and numeric values select yr
data and use:

Sub deletstuff2()
For Each cell in Selection
If cell = ""total board" or cell = "total metal" or IsNumeric(cell)
Then
cell.Delete
End If
Next cell