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

This controls the range of cells where scrolling is allowed.
Any cells outside this area cannot be selected.

Worksheets(1).ScrollArea = "A1:E20" 

Set this property to an empty string to enable cell selection on the entire worksheet.

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