WORKBOOK.SCROLL macro

Scrolls through the sheets in a workbook.

Syntax

WORKBOOK.SCROLL(num_sheets, firstlast_logical)

Num_sheets. is a number specifying how many sheets to scroll and the direction of scrolling. Positive numbers scroll forward by that many sheets. Negative numbers scroll backward by that many sheets. Zero (0) does not scroll.

Firstlast_logical    specifies whether to scroll to the first or last sheet in the workbook. If TRUE, scrolls to the last sheet in the workbook. If FALSE, scrolls to the first sheet in the workbook. If this argument is specified, then num_sheets is ignored.

Return to index