Stupid Scroll Bar!

[lemour]

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!

 

[Jack in the UK]

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.

 

[Kittmor]

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...

 

[Ivan F Moala]

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

 

[Jack in the UK]

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...