VSCROLL

Macro Sheets Only

Vertically scrolls through the active sheet by percentage or by row number.

Syntax

VSCROLL(position, row_logical)

Position specifies the row you want to scroll to. Position can be an integer representing the row number or a fraction or percentage representing the vertical position of the row in the sheet. If position is 0, VSCROLL scrolls through your sheet to its top edge, which is row 1. If position is 1, VSCROLL scrolls through your sheet to its bottom edge, which is row 16, 384. For charts that do not size with the window, use a fraction or percentage.

Row_logical is a logical value specifying how the function scrolls.

• If row_logical is TRUE, VSCROLL scrolls through the sheet to row position.
• If row_logical is FALSE or omitted, VSCROLL scrolls through the sheet to the vertical position represented by the fraction position.

Remarks

• To scroll to a specific row n, either use VSCROLL(n, TRUE) or VSCROLL(n/16384). To scroll to row 138, for example, enter VSCROLL(138, TRUE) or VSCROLL(138/16384).
• If you are recording a macro and move the scroll box several times in a row, the recorder only records the final location of the scroll box, omitting any intermediate steps. Remember that scrolling does not change the active cell or the selection.

Related Functions

FORMULA.GOTO Selects a named area or reference on any open workbook

HLINE Horizontally scrolls through the active window by columns

HPAGE Horizontally scrolls through the active window one window at a time

HSCROLL Horizontally scrolls through a sheet by percentage or by column number

SELECT Selects a cell, object, or chart item

VLINE Vertically scrolls through the active window by rows

VPAGE Vertically scrolls through the active window one window at a time

List of Command-Equivalent Functions