NamedRange::AutoFill Method (Range^, XlAutoFillType)

Automatically fills the cells in the NamedRange control.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

C++

Object^ AutoFill(
	Range^ Destination,
	XlAutoFillType Type = XlAutoFillType::xlFillDefault
)

Parameters

Destination: Type: Microsoft.Office.Interop.Excel::Range^
The cells to be filled. The destination must include the source range.

Type

Type: Microsoft.Office.Interop.Excel::XlAutoFillType

Specifies the fill type.

Can be one of these XlAutoFillType values:

If this argument is xlFillDefault or omitted, Microsoft Office Excel selects the most appropriate fill type, based on the source range.

Return Value

Type: System::Object^

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example sets the value 5 in cell A1, and then uses the AutoFill method to automatically fill cells A1 through A20 with the value in cell A1.

This example is for a document-level customization.

C++

No code example is currently available or this language may not be supported.