Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Stupid Scroll Bar!

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

    Default

    When you first start a new worksheet, the bottom of the scroll bar is the bottom of the last line of data. Once you scroll all the way down to the bottom of a worksheet, the scroll bar becomes stretched and the slider becomes small. Now the bottom of the scrollbar does not match with the last line of the data. Is there any way to reset this to again reflect the bottom of the data?

    Help! This is driving me nuts!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    Once moved i beleive this is standard...

    The scroll bar can be amended / adjusted.. in widit of bar and min max point if that helps.



    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Manhattan Beach California
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Lemour-

    I hate when that happens...
    By hiding the remaining empty rows, you won't "stretch out" the scroll bar. Go to the first unnecessary, empty row at the bottom of your spreadsheet, Highlignt, Hold Control, Shift & down arrow key, Right click, Hide.

    though, I'm sure there is another way...

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes this is an anoyance in that it doesn't
    give you the true range of the sheet.
    eg placing data @ A2000 sets the scroll bar
    appropriately...then deleting the data does
    not reset the scrollbar.

    To reset it you can do one of 2 things
    1) Save the workbook
    2) run this code

    Sub ResetLastRange()
    ActiveSheet.UsedRange
    End Sub


    Kind Regards,
    Ivan F Moala From the City of Sails

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nice touch Ivan

    To add tch Data in MS HQ agrees with my above post, seems only to effect the col or row thats manual altered rest should still auto adjust.. no reset it seems...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

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
  •