Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete row if text in cell
Add another "Or" and add "Not IsNumeric(.Cells(Lrow, "H"))
HTH Otto "KelliInCali" wrote in message ... I need to identify a row in which column D contains text in order to delete the row. Basically, I want to delete any rows for which D does not have a whole number greater than zero. Here is what I'm already working with, which identifies blanks and numbers less than zero, but it does not remove rows that remain containing text. With ActiveSheet .DisplayPageBreaks = False StartRow = 1 EndRow = .Cells(.Rows.Count, "D").End(xlUp).Row For Lrow = EndRow To StartRow Step -1 If .Cells(Lrow, "H").Value < 0.01 Or _ .Cells(Lrow, "H").Value = "" Then .Rows(Lrow).Delete End If Next End With tia, kelli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to delete a row with a cell containing certain number or text | Excel Discussion (Misc queries) | |||
delete text in a cell using certian criteria | Excel Discussion (Misc queries) | |||
delete part of text from a cell | Excel Worksheet Functions | |||
Delete cell with red text | Excel Programming | |||
Delete text from cell containing text and numbers? | Excel Programming |