Mary

You can reset the used range manually as Otto has pointed out or you can use a
macro.

See Debra Dalgleish's site for instructions and code.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 09:18:02 -0700, Mary Barnich-Tampa <Mary
wrote:

Excel often loses its End of File marker so that using Cntl PageDown or
CntlEnd does not go to the last cell in the file. Is there a way to reset
this?