FillUp Method

Applies To

Range Object.

Description

Fills up from the bottom cell or cells of the range to the top. Copies the contents and formats of the cell or cells in the bottom row of a range into the rest of the rows in the range.

Syntax

object.FillUp

object

Required. The range to fill.

See Also

AutoFill Method, FillDown Method, FillLeft Method, FillRight Method.

Example

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

Worksheets("Sheet1").Range("A1:A10").FillUp