XlAutoFillType XlAutoFillType XlAutoFillType Enum

Definition

Specifies how the target range is to be filled, based on the contents of the source range.

public enum class XlAutoFillType
public enum XlAutoFillType
Public Enum XlAutoFillType
Inheritance
XlAutoFillTypeXlAutoFillTypeXlAutoFillType

Fields

xlFillCopy xlFillCopy xlFillCopy 1

Copy the values and formats from the source range to the target range, repeating if necessary.

xlFillDays xlFillDays xlFillDays 5

Extend the names of the days of the week in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.

xlFillDefault xlFillDefault xlFillDefault 0

Excel determines the values and formats used to fill the target range.

xlFillFormats xlFillFormats xlFillFormats 3

Copy only the formats from the source range to the target range, repeating if necessary.

xlFillMonths xlFillMonths xlFillMonths 7

Extend the names of the months in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.

xlFillSeries xlFillSeries xlFillSeries 2

Extend the values in the source range into the target range as a series (e.g., '1, 2' is extended as '3, 4, 5'). Formats are copied from the source range to the target range, repeating if necessary.

xlFillValues xlFillValues xlFillValues 4

Copy only the values from the source range to the target range, repeating if necessary.

xlFillWeekdays xlFillWeekdays xlFillWeekdays 6

Extend the names of the days of the workweek in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.

xlFillYears xlFillYears xlFillYears 8

Extend the years in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.

xlFlashFill xlFlashFill xlFlashFill 11

Extend the values from the source range into the target range based on the detected pattern of previous user actions, repeating if necessary.

xlGrowthTrend xlGrowthTrend xlGrowthTrend 10

Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers in the source range are multiplicative (e.g., '1, 2,' is extended as '4, 8, 16' assuming that each number is a result of multiplying the previous number by some value). Formats are copied from the source range to the target range, repeating if necessary.

xlLinearTrend xlLinearTrend xlLinearTrend 9

Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers is additive (e.g., '1, 2,' is extended as '3, 4, 5' assuming that each number is a result of adding some value to the previous number). Formats are copied from the source range to the target range, repeating if necessary.

Applies to