Sheets.FillAcrossSheets method (Excel)

Copies a range to the same area on all other worksheets in a collection.

Syntax

expression.FillAcrossSheets (Range, Type)

expression A variable that represents a Sheets object.

Name	Required/Optional	Data type	Description
Range	Required	Range	The range to fill on all the worksheets in the collection. The range must be from a worksheet within the collection.
Type	Optional	XlFillWith	Specifies how to copy the range.

This example fills the range A1:C5 on Sheet1, Sheet5, and Sheet7 with the contents of the same range on Sheet1.

x = Array("Sheet1", "Sheet5", "Sheet7") 
Sheets(x).FillAcrossSheets _ 
 Worksheets("Sheet1").Range("A1:C5")