[RESOLVED] Macro does not work

[isnoend07]

Not very familiar with excel 2000
First time i used this macro it worked on another worksheet, but not this one

Public Sub RemoveRows()
Dim SearchString As String
Dim i As Long
SearchString = "Authorization"
i = 1

Do While i <= ThisWorkbook.ActiveSheet.Range("A1").CurrentRegion.Rows.Count
Debug.Print ThisWorkbook.ActiveSheet.Cells(i, 3).Text
    If InStr(1, ThisWorkbook.ActiveSheet.Cells(i, 3).Text, SearchString, vbTextCompare) > 0 Then
        ThisWorkbook.ActiveSheet.Cells(i, 1).EntireRow.Delete
    Else
        i = i + 1
    End If
Loop

Debug giving these results
33
39
free
44
35
what is the problem ?

[GBeats]

Is the active sheet the sheet you think it is?
i cannot see your data the image is not clear so im not sure where the data might be coming from.

[isnoend07]

Thanks got it to work by looping from the bottom