Applies To
Range Object.
Description
Fills down from the top cell or cells of the range to the bottom. Copies the contents and formats of the cell or cells in the top row of a range into the rest of the rows in the range.
Syntax
object.FillDown
object
Required. The range to fill.
See Also
AutoFill Method, FillLeft Method, FillRight Method, FillUp Method.
Example
This example fills the range A1:A10 on Sheet1, based on the contents of cell A1.
Worksheets("Sheet1").Range("A1:A10").FillDown