none
Delete rows using a Macro RRS feed

  • Question

  • I have different forms that I need to delete certain rows for all the worksheets.  I need a simple macro that can do this instead of doing it one at a time
    Tuesday, March 10, 2015 3:13 PM

All replies

  • Well, there is not a lot of detail in your question, but you can use a macro like this to delete rows 2, 4 , and 6 from every sheet in your active workbook.

    Sub Test()
        Dim W As Worksheet
        
        For Each W In Worksheets
            W.Range("A2,A4,A6").EntireRow.Delete
        Next W

    End Sub


    • Proposed as answer by ryguy72 Friday, March 13, 2015 2:24 AM
    Tuesday, March 10, 2015 4:44 PM