CODEWITHSUNDEEP
vba
6diegodiego9
6diegodiego9

Reputation: 596

AutoFill vs FillDown: what's the difference?

AutoFill: https://learn.microsoft.com/en-us/office/vba/api/excel.range.autofill
FillDown: https://learn.microsoft.com/en-us/office/vba/api/excel.range.filldown

What are the difference between the two?

The description of AutoFill in the MS documentation is: "Performs an autofill on the cells in the specified range."
Totally useless...

Upvotes: 1

Views: 2100

Answers (1)

Dilnoor Singh
Dilnoor Singh

Reputation: 518

For Autofill

expression.AutoFill (Destination, Type)

The type parameter controls how the information is going to be copied onto the destination cells. This page lists them all. So you have control over whether only the values or formats or patterns of the source cells will be copied.

For FillDown

There is no such control. And as the documentation quotes

The contents and formatting of the cell or cells in the top row of a range are copied into the rest of the rows in the range.

Upvotes: 3

Related Questions