| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
To delete certain data in excel. eg contains #DIV/0?
Sub ClearDivideByZero()
Dim rng as Range, cell as Range set rng = cells.specialcells(xlFormulas,xlErrors) for each cell in rng if cell.Text = "#DIV/0" then cell.ClearContent end if Next End Sub -- Regards, Tom Ogilvy "Winter" wrote: I have a set of data that I applied "If" condition.How to empty the cell with result "#DIV/0" ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - 2003 - Delete data if conditions met | Excel Discussion (Misc queries) | |||
| delete bad data point in excel 2007 | New Users to Excel | |||
| Excel - how do I delete data but not formulae? | Excel Discussion (Misc queries) | |||
| delete repeated data in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
