End of Sheet flag

[Duncan]

I have had this problems a few times now.
If you go to a long way down the sheet and type in a cell, then excel thinks that this is where the sheet ends (in terms of the scroll bar). I also think that this means the spreadsheet gets very large.

Is there anyway to "reset" the end of sheet?

Thanks
Duncan

 

[Juan Pablo González]

Make sure you eliminate that cell. Deleting the contents won't do. Then, you have some choices, one, the fastest, save the file. The other one, in VB Editor, in the Inmediate Pane, type

ActiveSheet.UsedRange