Window.WindowNumber property (Excel)

  • Article

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.

ActiveWindow.NewWindow 
MsgBox ActiveWindow.WindowNumber

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.