Worksheet.CopyPaste

CopyPaste(Cell, Area)

CopyPaste(Cell, Area, CopyPasteProperties)

CopyPaste(Int32, Int32, Area)

CopyPaste(Int32, Int32, Area, CopyPasteProperties)

Copies an area of cells from a Worksheet in either the same workbook or another workbook.
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 currently support copying anything not listed above, including charts, images, or autofilters.

CopyPaste(String, Area)

CopyPaste(String, Area, CopyPasteProperties)