View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DFrank DFrank is offline
external usenet poster
 
Posts: 28
Default 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.