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.
Syntax
expression.FillLeft
expression Required. An expression that returns a Range object.