We recommend using Visual Studio 2017

How to: 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.


This example requires a range named rangeData in a worksheet.

Working 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