Marco to Delete rows

[ironsides]

Sheet starts on row 19 Cell A


Marco needed to
delete Rows 19 thru 1931

 

[Dazzawm]

Why can you not highlight the range, right click and delete?

 

[ironsides]

Why can you not highlight the range, right click and delete?

No too repetitious

 

[Dryver14]

Sub DeleteSomeRows()
Cells(20, 1).Resize(1911, 1).EntireRow.Delete
End Sub

I agree with Daz

 

[Michael M]

Me too...maybe this was an assignment ?

Sub DeletetheRows()
Rows("20:1911").Delete
End Sub

 

[Dryver14]

well if nothing else I learned a shorter way thanks Michael.

change 20 to 19 on both macros

 

[ironsides]

Me too...maybe this was an assignment ?

Sub DeletetheRows()
Rows("20:1911").Delete
End Sub

Thanks Dryver14 and Michael M Does the trick and saves me lots of time