How to: Copy Worksheets within a Workbook

This example demonstrates how to create a copy of an existing worksheet. To do this, follow the steps below.

  • Create an empty worksheet in a workbook. For example, call the WorksheetCollection.Add method.
  • Access the newly created worksheet object and call its Worksheet.CopyFrom method with the source worksheet object passed as a parameter.

View Example

// Add a new worksheet to a workbook.

// Copy all information (content and formatting) to the newly created worksheet 
// from the "Sheet1" worksheet.