HSCROLL

Macro Sheets Only

Horizontally scrolls through the active sheet by percentage or by column number.

Syntax

HSCROLL(position, col_logical)

Position specifies the column you want to scroll to. Position can be an integer representing the column number or a fraction or percentage representing the horizontal position of the column in the sheet. If position is 0, HSCROLL scrolls through your sheet to its leftmost edge. If position is 1, HSCROLL scrolls through your sheet to its rightmost edge. For charts that do not size with the window, use a fraction or percentage.

Col_logical is a logical value specifying how the function scrolls.

• If col_logical is TRUE, HSCROLL scrolls through the sheet to column position.
• If col_logical is FALSE or omitted, then HSCROLL scrolls through the sheet to the horizontal position represented by the fraction position.

Remarks

• To scroll to a specific column n, either use HSCROLL(n, TRUE) or use HSCROLL(n/256). To scroll to column 38, for example, use HSCROLL(38, TRUE) or HSCROLL(38/256).
• 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

HLINE Horizontally scrolls through the active window by columns

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

VLINE Vertically scrolls through the active window by rows

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

VSCROLL Vertically scrolls through a sheet by percentage or row number

List of Command-Equivalent Functions