| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete row based on value of cell in row
I am attempting to loop through each row of the used range of a sheet, and
then delete it based on its contents. My code is failing. Any help would be appreciated. Thanks in advance. For i = 8 To ActiveSheet.UsedRange.Rows.Count Set x = Cells(i, 6).value If Not IsNumeric(x) Then ActiveSheet.Rows(i).Delete End If Next i |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete ROW based on Cell Contents | Excel Discussion (Misc queries) | |||
| Delete row based on cell value | Excel Discussion (Misc queries) | |||
| delete row on based on cell value | Excel Discussion (Misc queries) | |||
| Delete Row based off cell content | Excel Discussion (Misc queries) | |||
| Delete Row based on cell contents | Excel Programming | |||
Threaded Mode
