LeftColumn Property

LeftColumn returns or sets the first visible column in the window. Returns a long.

Syntax

object.LeftColumn

object.LeftColumn = Col

Parameter

Type

Description

Col

Variant

required

Example 1

This example demonstrates how to return the first column visible in a worksheet window.

Debug.Print WksWindow.LeftColumn

Example 2

This example demonstrates how to set column C as the first column visible in a worksheet window. You can set the number of the column or the letter in double quotes.

WksWindow.LeftColumn="C"

or,

WksWindow.LeftColumn=3

Used by: WksWindow object