Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi i found the below code that seaches col b for any cell that
contains the word verifiers and deletes the enrire row if found but can someone explain how it does it i understand most of it but i cant get my head round thr step -1 part cheers Sub del_row() Dim rw As Integer Dim Word As String Word = "Verifiers" For rw = 2000 To 2 Step -1 If InStr(2, ActiveSheet.Cells(rw, 2).Value, Word, vbTextCompare) Then Cells(rw, 2).EntireRow.Delete Next rw End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not sure how to explain.... | Excel Discussion (Misc queries) | |||
explain this one to me.... | Excel Discussion (Misc queries) | |||
How to explain??... | Excel Discussion (Misc queries) | |||
Let me see if I can explain this... | Excel Worksheet Functions | |||
Explain these please | Excel Worksheet Functions |