<div>
I'm not a huge fan of this method I'm about to suggest, but you can hide all rows from 421 to the last row. &nbsp;That will limit the display to row 420.<br />
<br />
If you have a macro-based option that deletes the rows as you described, you could augment it to unhide an equal amount of rows below to keep the display at 420 rows. &nbsp;<br />
<br />
Regards,<br />
-Glenn
</div>


I'm not a huge fan of this method I'm about to suggest, but you can hide all rows from 421 to the last row.  That will limit the display to row 420.

If you have a macro-based option that deletes the rows as you described, you could augment it to unhide an equal amount of rows below to keep the display at 420 rows.  

Regards,
-Glenn

<div>
Just a follow-up: &nbsp;If you do hide rows 421-onward, they will stay hidden even if you delete rows in the visible area.
</div>


Just a follow-up:  If you do hide rows 421-onward, they will stay hidden even if you delete rows in the visible area.

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have mulitple worksheets within a workbook. &nbsp;I want each worksheet to have only 420 rows and no more. &nbsp;Is there a way in VB, I can delete all rows after row 420.<br />
<br />
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.
</div>
</div>


Experts,

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.

Ensuring a spreadsheet has only 420 rows in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.