End of Sheet flag

Duncan · Feb 18th, 2002, 08:30 AM

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 · Feb 18th, 2002, 09:03 AM

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

Code:

ActiveSheet.UsedRange

Feb 18th, 2002, 09:03 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	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 Code: ActiveSheet.UsedRange __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 08:30 AM	#1
Duncan New Member Join Date: Feb 2002 Posts: 8	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