Range.FillLeft Method
| Excel Developer Reference |
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 A variable that represents a Range object.
Return Value
Variant
Example
This example fills the range A1:M1 on Sheet1, based on the contents of cell M1.
| Visual Basic for Applications |
|---|
|
See Also