xlAutoFillType

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

xlFillCopyCopy the values and formats from the source range to the target range, repeating if necessary (1)
xlFillDaysExtend 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 (5)
xlFillDefault*Excel determines the values and formats used to fill the target range (0)
xlFillFormatsCopy only the formats from the source range to the target range, repeating if necessary (3)
xlFillMonthsExtend 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 (7)
xlFillSeriesExtend 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 (2)
xlFillValuesCopy only the values from the source range to the target range, repeating if necessary (4)
xlFillWeekdaysExtend 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 (6)
xlFillYearsExtend the years in the source range into the target range
Formats are copied from the source range to the target range, repeating if necessary (8)
xlFlashFill(Added in 2013)
xlGrowthTrendExtend 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 (10)
xlLinearTrendExtend 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 (9)

xlFillCopy
Copy the values and formats from the source range to the target range, repeating if necessary (1)
xlFillDays
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 (5)
xlFillDefault*
Excel determines the values and formats used to fill the target range (0)
xlFillFormats
Copy only the formats from the source range to the target range, repeating if necessary (3)
xlFillMonths
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 (7)
xlFillSeries
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 (2)
xlFillValues
Copy only the values from the source range to the target range, repeating if necessary (4)
xlFillWeekdays
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 (6)
xlFillYears
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 (8)
xlFlashFill
(Added in 2013)
xlGrowthTrend
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 (10)
xlLinearTrend
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 (9)


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top