Ensuring a spreadsheet has only 420 rows in Excel
Posted on 2014-09-05
I have mulitple worksheets within a workbook. I want each worksheet to have only 420 rows and no more. Is there a way in VB, I can delete all rows after row 420.
I have the spreadsheet set to display only up to 420, but however I am performing a delete operation which deletes rows from the original 420 when there is no data on the respective row.