| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows for values
Hello,
I have code that I hoped would iterate through a column and delete rows if values did not begin with a 7. For Each rngDBSingleCostElemCell In wksSheet.Range("C2:C" & lCostElemItemLastRow) If Left(rngDBSingleCostElemCell, 1) < 7 Then rngDBSingleCostElemCell.Rows.Delete End If Next rngDBSingleCostElemCell The values in column C are numbers stored as text. For some reason rows with values like 16101, 16151 remain. thanks for any help. Jake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows with duplicated values | Excel Discussion (Misc queries) | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| delete rows with 0 values | Excel Programming | |||
| Delete Rows where there are #N/A Values | Excel Worksheet Functions | |||
| Delete rows with numeric values, leave rows with text | Excel Programming | |||
Threaded Mode
