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
Lightly tested
Sub deleteRowsNonNumericColumnE() Dim I As Long With ActiveSheet For I = .Cells(.Rows.Count, 5).End(xlUp).Row To 4 Step -1 If Not IsNumeric(.Cells(I, 5).Value) Then .Rows(I).Delete Next I End With End Sub -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Peruanos72" wrote: 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 | |||
New Spreadsheet Created Based on Value Column "O" (alpha) | 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 |