Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find part of string & delete row
Hi all, use the code below to find "Total" to delete the row, Total is
part of the string & i am not sure how to change the code to find "Total" even if it is part of a string ? Sub DeleteTotalSuppSAP() ' ' Dim i As Long Dim iLastRow As Long iLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = iLastRow To 1 Step -1 If InStr(1, Cells(i, "G").Value, "total", vbTextCompare) Then Rows(i).Delete End If Next i End Sub Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete part of a text string | Excel Worksheet Functions | |||
delete a - if it is the last part of a string | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Use a formula to delete part of a text string? | Excel Worksheet Functions | |||
How do I delete part of a text string in every cell it appears in | Excel Discussion (Misc queries) |