- The copied data will overwrite the contents of the cells in this worksheet.
- You may specify the types of data copied (cell value, formulas, comments, formatting, etc.) using the CopyPasteProperties object.
- The CopyPaste method supports copying column width, comments, formulas, merged cells, row height, values, and cell and number formatting.
- The CopyPaste method does not copy conditional formatting.
- When formulas are copied, references to ranges are updated to refer to the new sheet.
|