End of Sheet flag
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: End of Sheet flag

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com