How do I specify an end to a worksheet to eliminate empty rows?

[David McRitchie]

Hi TexasUser, (I hope that isn't your real name)
Please take the time to ask the question in the body so we know there is a
question, it might also avoid being so ambiguous that the real question is
unknown.

I am going to guess that Cntrl+End takes you past where you think your
data actual is. For that I would suggest fixing the entire workbook at once
with DeleteUnuseda macro. at
Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish
http://www.contextures.com/xlfaqApp.html#Unused
I wouldn't even bother with instructions to delete rows/columns manually..
Upon completion of the macro, it would be a good idea to save the workbook.

If you have a problem with empty rows between your good data
Delete Cells/Rows in Range, based on empty cells, or cells with specific values
Delete ALL rows that are Entirely Blank (#RemoveEmptyRows)
http://www.mvps.org/dmcritchie/excel/delempty.htm#RemoveEmptyRows

 

[Texasuser]

Thank you!

Hi TexasUser, (I hope that isn't your real name)
Please take the time to ask the question in the body so we know there is a
question, it might also avoid being so ambiguous that the real question is
unknown.

I am going to guess that Cntrl+End takes you past where you think your
data actual is. For that I would suggest fixing the entire workbook at once
with DeleteUnuseda macro. at
Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish
http://www.contextures.com/xlfaqApp.html#Unused
I wouldn't even bother with instructions to delete rows/columns manually..
Upon completion of the macro, it would be a good idea to save the workbook.

If you have a problem with empty rows between your good data
Delete Cells/Rows in Range, based on empty cells, or cells with specific values
Delete ALL rows that are Entirely Blank (#RemoveEmptyRows)
http://www.mvps.org/dmcritchie/excel/delempty.htm#RemoveEmptyRows
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm