This documentation is archived and is not being maintained.

XlInsertFormatOrigin Enumeration 

Specifies from where to copy the format for inserted rows.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlInsertFormatOrigin1 As XlInsertFormatOrigin = XlInsertFormatOrigin.xlFormatFromLeftOrAbove

Public Enum XlInsertFormatOrigin
public enum XlInsertFormatOrigin
public enum XlInsertFormatOrigin

Member nameDescription
xlFormatFromLeftOrAboveFrom cells above and/or to the left.
xlFormatFromRightOrBelowFrom cells below and/or to the right.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms