MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Delete Empty Rows


Posted by thomas venn on January 16, 2002 10:36 AM

Hello,

Way back a few months ago, there was a question regarding the ability to delete empty rows. By this I mean having Excel no longer recognize the empty rows as still containing data. For example, If I delete all my data from rows 500 to 65000, then I press Control+End, I go to row 65000. What I want is to have excel go to row 499, because that is the last row, but Excel is going to row 65000 because there was data there before. Any help is appreciated.

Thanks,

- Thomas


Posted by Tom Urtis on January 16, 2002 11:00 AM

What you may have seen is a procedure to help do this, such as

Sub Reset()
ActiveSheet.UsedRange
End Sub

which should do the trick, assuming there are no formulas or values in any of those rows.


Tom Urtis

Posted by Mark W. on January 16, 2002 11:58 AM

After deleting the rows perform a Save (nt)