Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use the following code to delete a row containing a particular string, but
if two succesive rows contain the string, the second row is skipped. How can I decrement the row counter, so that after a deletion the next for loop works on the same row? For Each C In myRange C.Select MyPos = InStr(1, C.Value, strWhat, 1) If MyPos 0 Then Response = MsgBox("Delete?", vbYesNo + vbQuestion) If Response = vbYes Then Selection.EntireRow.Delete End If End If Next Any help would be much appreciated, Sue -- I''m not a complete idiot - there are some parts missing! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
#Ref! after row deletion | Excel Discussion (Misc queries) | |||
Subtract two dates (decrementing daily) and add text | Excel Worksheet Functions | |||
name deletion | Excel Discussion (Misc queries) | |||
dup value deletion | Excel Programming | |||
Row Deletion | Excel Programming |