Move to Bottom of Worksheet Range with Scrollbar

[Gos-C]

How can I set my worksheet to see last row of the worksheet range when
move the scrollbar to the bottom

 

[Frank Kabel]

Hi
see:
http://www.contextures.com/xlFunctions02.html

 

[Gord Dibben]

Or maybe even.......<g>

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

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi Gord
thanks for the correction. Should be more careful with my mosue )

 

[David McRitchie]

Don't know why you would want to make it permanent, try
the SHIFT+ scrolling for "smooth scrolling", which will
take you fast to the bottom of the entire worksheet.

I like that the scroll bar ends at the bottom or right side of
the usedrange, but you can scroll past that as indicated.

Kind of the opposite of what you asked. For macros
and toolbar buttons that take you to the top of a column or to
the used cell in a column see macro and toolbar buttons
with arrows to go with the macros in
http://www.mvps.org/dmcritchie/excel/excel.htm