This documentation is archived and is not being maintained.

FillLeft Method [Excel 2003 VBA Language Reference]

Office 2003

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


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


Applies to | Range Collection