Worksheets.FillAcrossSheets Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub FillAcrossSheets ( _
    Range As Range, _
    Type As XlFillWith _
)
'Usage
Dim instance As Worksheets
Dim Range As Range
Dim Type As XlFillWith

instance.FillAcrossSheets(Range, Type)

void FillAcrossSheets(
    Range Range,
    XlFillWith Type
)

Parameters

• Range
  Type: Microsoft.Office.Interop.Excel.Range

  Required Range object. The range to fill on all the worksheets in the collection. The range must be from a worksheet within the collection.

• Type
  Type: Microsoft.Office.Interop.Excel.XlFillWith

  Optional XlFillWith. Specifies how to copy the range.

See Also

Reference

Worksheets Interface

Worksheets Members

Microsoft.Office.Interop.Excel Namespace