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