Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete row if cell in column "E" has 1 or more alpha characters
Try this:
Sub DeleteNonNumericRows() LastRow = Range("E" & Rows.Count).End(xlUp).Row For r = LastRow To 4 Step -1 If Not IsNumeric(Cells(r, "E")) Then Rows(r).Delete End If Next End Sub Hopes this helps. --- Per "Peruanos72" skrev i meddelelsen ... I'm trying to delete rows of data after row 4 if the cell in column "E" has any alpha characters in it at all. If the cell in column "E" is all numeric then no action is taken on that row. Thoughts?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete row if cell in column "E" has 1 or more alpha characters | Excel Programming | |||
Disabling "Entire &row/&column" in Delete/Insert Cell | Excel Programming | |||
Find the word "total" in a cell, delete row or column | Excel Programming | |||
Find the word "total" in a cell, delete row or column | Excel Programming | |||
Find the word "total" in a cell, delete row or column | Excel Programming |