Macro Deleting Row at Test Character

I need to know how to have a macro decend down a column until the cursor hits a cell containing a test character and then select the row the test character is on to delete.

 

One thought on “Macro Deleting Row at Test Character

  1. Katie

    Hello

    Try this… it assumes your test character is “A” and located in column B…

    Sub Row_Removal()
    Dim Test As String

    Test = "A"
    X = 1

    Do Until Cells(X, 2) = Test
    X = X + 1
    Loop

    Cells(X, 2).EntireRow.Select
    Selection.Delete

    End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *