Window.WindowNumber Property

Excel Developer Reference

Returns the window number. For example, a window named "Book1.xls:2" has 2 as its window number. Most windows have the window number 1. Read-only Long.

Syntax

expression.WindowNumber

expression   A variable that represents a Window object.

Remarks

The window number isn't the same as the window index (the return value of the Index property), which is the position of the window within the Windows collection.

Example

This example creates a new window of the active window and then displays the window number of the new window.

Visual Basic for Applications
  ActiveWindow.NewWindow
MsgBox ActiveWindow.WindowNumber

See Also