MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Clearing from a certain row all the way to the bottom using VB


Posted by Geoff on July 10, 2001 11:56 AM

What I'm trying to do is clear an entire Worksheet from the 5th row down using VB. I misposted my previous question and asked how to clear the entire sheet. Is there a way to do this? Thanks in advance :)

Geoff


Posted by Barrie Davidson on July 10, 2001 12:12 PM

Try,
Rows("5:" & ActiveCell.SpecialCells(xlLastCell).Row).Delete

This will delete all rows from the fifth row (including the fifth row) to the end of the spreadsheet.

Regards,
Barrie