Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2012
Office Development in Visual Studio
Create Add-ins and Customizations for Office by using Visual Studio
Managed Reference (Office Development in Visual Studio)
Microsoft.Office.Tools.Excel
NamedRange Interface
NamedRange Methods
_PasteSpecial Method
_PrintOut Method
Activate Method
AddComment Method
AdvancedFilter Method
AllocateChanges Method
ApplyNames Method
ApplyOutlineStyles Method
AutoComplete Method
AutoFill Method
AutoFilter Method
AutoFit Method
AutoFormat Method
AutoOutline Method
BorderAround Method
BorderAround2 Method
Calculate Method
CalculateRowMajorOrder Method
CheckSpelling Method
Clear Method
ClearComments Method
ClearContents Method
ClearFormats Method
ClearHyperlinks Method
ClearNotes Method
ClearOutline Method
ColumnDifferences Method
Consolidate Method
Copy Method
CopyFromRecordset Method
CopyPicture Method
CreateNames Method
CreatePublisher Method
Cut Method
DataSeries Method
Delete Method
DialogBox Method
Dirty Method
DiscardChanges Method
EditionOptions Method
ExportAsFixedFormat Method
FillDown Method
FillLeft Method
FillRight Method
FillUp Method
Find Method
FindNext Method
FindPrevious Method
FunctionWizard Method
get_Address Method
get_AddressLocal Method
get_Characters Method
get_End Method
get_Item Method
get_Offset Method
get_Range Method
get_Resize Method
get_Value Method
GetEnumerator Method
GoalSeek Method
Group Method
Insert Method
InsertIndent Method
Justify Method
ListNames Method
Merge Method
NavigateArrow Method
NoteText Method
Parse Method
PasteSpecial Method
PrintOut Method
PrintOutEx Method
PrintPreview Method
RemoveDuplicates Method
RemoveSubtotal Method
Replace Method
RowDifferences Method
Run Method
Select Method
set_Item Method
set_Value Method
SetPhonetic Method
Show Method
ShowDependents Method
ShowErrors Method
ShowPrecedents Method
Sort Method
SortSpecial Method
Speak Method
SpecialCells Method
SubscribeTo Method
Subtotal Method
Table Method
TextToColumns Method
Ungroup Method
UnMerge Method
Expand Minimize
This topic has not yet been rated - Rate this topic

NamedRange.AutoFill Method

Visual Studio 2012

Automatically fills the cells in the NamedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
C#
VB
Copy 
Object AutoFill(
	Range Destination,
	XlAutoFillType Type
)

Parameters

Destination
Type: Range

The cells to be filled. The destination must include the source range.

Type
Type: XlAutoFillType

Specifies the fill type.

Can be one of these XlAutoFillType values:

xlFillDays

xlFillFormats

xlFillSeries

xlFillWeekdays

xlGrowthTrend

xlFillCopy

xlFillDefault

xlFillMonths

xlFillValues

xlFillYears

xlLinearTrend

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

Return Value

Type: Object

Optional Parameters

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

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#
VB
Copy 
private void SetAutoRange()
{
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1"],
        "namedRange1");

    namedRange1.Value2 = 5;
    namedRange1.AutoFill(this.Range["A1", "A20"],
        Excel.XlAutoFillType.xlFillDefault);
}
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.