Window.WindowNumber Property (Excel)

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.

expression .WindowNumber

expression A variable that represents a Window object.

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.

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
Show: