Window.Type (Excel)

Returns or sets an XlWindowType value that represents the window type. Possible return values are xlChartAsWindow - The chart will open in a new window, xlChartInPlace - The chart will be displayed on the current worksheet, xlClipboard - The chart is copied to the clipboard, xlWorkbook - This constant applies to Macintosh only.

Dim xwtType As XlWindowType
xwtType = ActiveWindow.Type