macro to delete certain results
I am making a macro that deletes #N/A's, but i want to add a few things to it
that should be deleted:
the phrases "total board" and "total metal", and any non-text (i.e. any
number) that appears.
this is what i have so far:
Public Sub DeleteStuff()
Cells.SpecialCells(xlCellTypeFormulas, xlErrors).Delete
End Sub
what do i add to meet my specifications? thanks.
|