AutoWksWindow Object

The AutoWksWindow object represents a single worksheet window.

Derived from: AutoWindow object (All methods and properties of AutoWindow apply to this object.)

Properties

ActiveCell

LeftColumn

Selection

TopRow

Example

The following script demonstrates how the AutoWksWindow object is used in reference to the AutoWindows collection.

Sub Main

 

 'Declares GrapherApp as an object

  Dim GrapherApp As Object

 

 'Creates an instance of the Grapher Application

 'object and assigns it to the variable named "GrapherApp"

  Set GrapherApp = CreateObject("Grapher.Application")

 

 'Makes Grapher visible

  GrapherApp.Visible = True

 

 'Declares Wks as an object

  Dim Wks As Object

 

 'Creates a worksheet document in Grapher

 'and assigns it to the variable named "Wks"

  Set Wks = GrapherApp.Documents.Add(grfWksDoc)

 

 'Declares WksWindow as an object

  Dim WksWindow As Object

 

 'Assigns the new plot window to the

 'variable named "WksWindow"

  Set WksWindow = Wks.NewWindow

 

End Sub