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