HLINE

Macro Sheets Only

Scrolls through the active window by a specific number of columns. Returns the #VALUE! error value if the active document is a chart.

Syntax

HLINE(num_columns)

Num_columns is the number of columns in the active worksheet or macro sheet you want to scroll through horizontally.

• If num_columns is positive, HLINE scrolls to the right.
• If num_columns is negative, HLINE scrolls to the left.
• Num_columns must be between -256 and 256, inclusive.

Example

The following function scrolls the active window by one-half window to the right:

HLINE(GET.WINDOW(15)/2)

Related Functions

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

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

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 document by percentage or by row number

List of Command-Equivalent Functions