FillLeft Method Example
This example fills the range A1:M1 on Sheet1, based on the contents of cell M1.
Worksheets("Sheet1").Range("A1:M1").FillLeft