Copies a range to the same area on all other worksheets in a collection.
x = Array("Sheet1", "Sheet5", "Sheet7") Sheets(x).FillAcrossSheets Worksheets("Sheet1").Range("A1:C5")
The following argument is required
Range (Range) - The range to fill on all the worksheets in the collection. The range must be from a worksheet within the collection.