| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I delete cells containing text within a range of cells
EXCEL 2003
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I delete cells containing text within a range of cells
Try this small macro:
Sub cleantext() For Each r In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants) If IsNumeric(r) Then Else r.Clear End If Next End Sub -- Gary''s Student - gsnu200790 "jackwmbg" wrote: EXCEL 2003 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I delete cells containing text within a range of cells
F5SpecialConstants. Checkmark in "Text" and OK.
EditDelete Gord Dibben MS Excel MVP On Fri, 6 Jun 2008 04:49:01 -0700, jackwmbg wrote: EXCEL 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADD A BUTTON TO A CELL TO DELETE A RANGE OF CELLS? | Excel Discussion (Misc queries) | |||
| delete all empty cells in a range | Excel Worksheet Functions | |||
| Need macro to delete all text cells in an Excel range | Excel Worksheet Functions | |||
| How do I delete text to right of a comma in a range of cells? | Excel Discussion (Misc queries) | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Linear Mode
