On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Sunday, February 8, 2015

VBA Code to Delete Multiple Rows in MS Excel

Use Below VBA Code to Delete Multiple Rows in MS Excel from your active worksheet

Sub DeleteRows()
'Delete the Row 2 and 4 in active worksheet
    Rows("2:2,4:4").Select
    Selection.Delete Shift:=xlUp
End Sub

Popular Posts