編輯

共用方式為


Sheets.FillAcrossSheets(Range, XlFillWith) Method

Definition

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

public void FillAcrossSheets (Microsoft.Office.Interop.Excel.Range Range, Microsoft.Office.Interop.Excel.XlFillWith Type = Microsoft.Office.Interop.Excel.XlFillWith.xlFillWithAll);

Parameters

Range
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
XlFillWith

Optional XlFillWith. Specifies how to copy the range.

Applies to