Navigating Sheets

Manoeuvring

Selection.End(xlDown).Select 
Selection.SpecialCells(xlCellTypeLastCell).Select 

Switching between worksheets

Worksheets("Sheet1").Activate 
Sheets("Sheet2").Select 
Sheets(2).Select 
Sheets(2).Activate 

Scrolling / Position

ActiveWindow.ScrollColumn 

This returns the column number in the top-left corner of the active window

ActiveWindow.ScrollRow 

This returns the row number in the top-left corner of the active window

ScrollArea

This controls the range of cells where scrolling is allowed.
Cells & Ranges > Scroll Area