Expand Minimize
This topic has not yet been rated - Rate this topic

Range.FillLeft Method (Excel)

Published: July 16, 2012

Fills left from the rightmost cell or cells in the specified range. The contents and formatting of the cell or cells in the rightmost column of a range are copied into the rest of the columns in the range.

expression .FillLeft

expression A variable that represents a Range object.

Return Value

Variant

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

Worksheets("Sheet1").Range("A1:M1").FillLeft

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.