Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows with 0 values
how can i create a macro that select column O, delete every row that contains
empty cells, cells with 0 values, and non-numeric cells such as --------. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows with 0 values
Sub test
dim rng as range For each rng in Range("O2", Range("O2").End(xlDown)) If rng.value = "0" or rng.value= "---------"Then rng.clear Next columns("O:O").SpecialCells(xlCellTypeBlanks).Enti reRow.Delete End sub Regards Jean-Yves "andresg1975" wrote in message ... how can i create a macro that select column O, delete every row that contains empty cells, cells with 0 values, and non-numeric cells such as --------. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows with duplicated values | Excel Discussion (Misc queries) | |||
Delete rows with duplicate values | Excel Discussion (Misc queries) | |||
How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
Delete Rows where there are #N/A Values | Excel Worksheet Functions | |||
Delete rows with numeric values, leave rows with text | Excel Programming |