Delete Last 10 Rows in Worksheet
Thank You All.
"Jim Thomlinson" wrote:
You can do it with this line of code...
Sheets("Sheet1").Cells(Rows.Count, _
"A").End(xlUp).Offset(-9).Resize(10).EntireRow.Delete
--
HTH...
Jim Thomlinson
"Sloth" wrote:
I need a macro that can delete the last ten rows in the worksheet. Column A
will always contain information on the last row, but has a lot of gaps in the
rest of the column.
|