Programmatically copy data and formatting across worksheets

You can copy data from a range on one sheet to all the other sheets in a workbook by using the FillAcrossSheets method. Specify a range, and whether you want to copy data, formatting, or both.

Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

Example

C#

this.Application.ActiveWorkbook.Sheets.FillAcrossSheets(
    this.Application.get_Range("rangeData"), 
    Excel.XlFillWith.xlFillWithAll);

VB

Me.Application.ActiveWorkbook.Sheets.FillAcrossSheets( _
    Me.Application.Range("rangeData"), Excel.XlFillWith.xlFillWithAll)

Compile the code

This example requires a range named rangeData in a worksheet.

Related content

• Work with worksheets
• How to: Programmatically add new worksheets to workbooks
• How to: Programmatically change formatting in worksheet rows containing selected cells
• Optional parameters in Office solutions