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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext