Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Way to reset the last cell to be EOF

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
How do I reset my opening cell back to A1? sloowhand Excel Discussion (Misc queries) 1 February 28th 06 12:55 AM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM


All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"