Excel.Window.SplitRow.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Window.SplitRow property (Excel)	vbaxl10.chm356114	vbaxl10.chm356114	Excel.Window.SplitRow	a1b900c3-4152-8701-db1f-1b576249c686	05/21/2019	medium

Window.SplitRow property (Excel)

Returns or sets the row number where the window is split into panes (the number of rows above the split). Read/write Long.

Syntax

expression.SplitRow

expression A variable that represents a Window object.

Example

This example splits the active window so that there are 10 rows above the split line.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate 
ActiveWindow.SplitRow = 10

[!includeSupport and feedback]