WindowNumber Property

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.

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.

ActiveWindow.NewWindow
MsgBox ActiveWindow.WindowNumber