Tandaan
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o baguhin ang mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
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.
Parameters
| 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. |
Example
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")
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.