Copies a range to the same area on all other worksheets in a collection.
Syntax
expression.FillAcrossSheets(Range, Type)
expression Required. An expression that returns a Sheets or Worksheets object.
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 Variant. Specifies how to copy the range. Can be one of the following XlFillWith constants: xlFillWithAll, xlFillWithContents, or xlFillWithFormulas. The default value is xlFillWithAll.