FillDown Method

expression.FillDown

expression    Required. An expression that returns a Range object.

Example

This example fills the range A1:A10 on the active worksheet, based on the contents of cell A1.

Spreadsheet1.ActiveSheet.Range("A1:A10").FillDown