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



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext