VBA code to delete specified rows on all worksheets

VBA code to delete specified rows on all worksheets

December 11, 2017

The below visual basic code, posted here, works well to delete the rows that you specify on all worksheets in a workbook.   Simply enter the range of your rows on the line beginning 'Rows'. 

 

 

 

 

Sub bleh()

    Dim xWs As Worksheet

    Set xWs = ActiveSheet

    ThisWorkbook.Worksheets.Select

    Rows("4:5").Select

    Selection.Delete

    xWs.Select

End Sub

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com