how can I delete cells containing text within a range of cells

how can I delete cells containing text within a range of cells

Post by amFja3dtYm » Sat, 07 Jun 2008 20:49:01


EXCEL 2003
 
 
 

how can I delete cells containing text within a range of cells

Post by R2FyeScncy » Sat, 07 Jun 2008 21:53:01

Try this small macro:

Sub cleantext()
For Each r In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants)
If IsNumeric(r) Then
Else
r.Clear
End If
Next
End Sub

--
Gary''s Student - gsnu200790

 
 
 

how can I delete cells containing text within a range of cells

Post by Gord Dibbe » Sun, 08 Jun 2008 05:08:30

F5>Special>Constants. Checkmark in "Text" and OK.

Edit>Delete


Gord Dibben MS Excel MVP

On Fri, 6 Jun 2008 04:49:01 -0700, jackwmbg < XXXX@XXXXX.COM >