Thanks for the website- I tried highlighing the rows and deleting and that
didn't reset the range. I even saved and closed but I have office 2007 so I
don't think that is an issue. They give a macro to programatically reset the
used range but I'm not quite sure how to use the macro-- do I have to put in
values or can I simply compy and paste it without adding or changing
anything? Also, every time I open and close this file, this message pops up :
Compile error in hidden module: DistMon-- think that has anything to do with
it?? Thanks!!

"FSt1" wrote:

hi
i think excel has lost it's used range reference.
see this site to reset.

http://www.contextures.com/xlfaqApp.html#Unuseda

regards
FSt1

"Kajuliano" wrote:

I am working on an excel file in which I currently have data in 1,650 rows
and there are blank cells within the rows I am working on that need to stay
blank. My main problem is deleteing the extra 65,536 blank rows below my data
that randomly appeared when I copy and pasted my data to a new workbook. When
I highlight a single blank row or many blank rows beneath my data and hit
delete row, they do not go away and it is really annoying because my scroll
bar had become all but useless- please help! Thanks!