Partager via


NamedRange.Copy Method

Copies the contents of the NamedRange control to the specified range or to the Clipboard.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Function Copy ( _
    Destination As Object _
) As Object
Object Copy(
    Object Destination
)

Parameters

  • Destination
    Type: System.Object

    Specifies the new range to which the contents of the NamedRange control will be copied. If this argument is omitted, Microsoft Office Excel copies the range to the Clipboard.

Return Value

Type: System.Object

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example uses the Copy method to copy the contents of a NamedRange control named NamedRange1 to the Clipboard, and then uses the PasteSpecial method to paste these contents into a NamedRange control named NamedRange2. The Operation parameter is set to xlPasteSpecialOperationAdd so that the content of each cell in NamedRange1 is added to the corresponding cell in NamedRange2.

This example is for a document-level customization.

Private Sub CopyAndPasteSpecialRange()
        Dim namedRange1 As Microsoft.Office.Tools.Excel.NamedRange _
            = Me.Controls.AddNamedRange(Me.Range("A1", "A3"), _
            "namedRange1")
        namedRange1.Value2 = 22

        Dim namedRange2 As Microsoft.Office.Tools.Excel.NamedRange _
            = Me.Controls.AddNamedRange(Me.Range("C1", "C3"), _
            "namedRange2")
        namedRange2.Value2 = 5

        ' Copy the contents of namedRange1 to the clipboard, and then 
        ' paste the contents into namedRange2, adding each value to 
        ' the value in namedRange2.
        namedRange1.Copy()
        namedRange2.PasteSpecial(Excel.XlPasteType.xlPasteAll, _
        Excel.XlPasteSpecialOperation.xlPasteSpecialOperationAdd, _
        False, False)
    End Sub
private void CopyAndPasteSpecialRange()
{
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1", "A3"],
        "namedRange1");
    namedRange1.Value2 = 22;

    Microsoft.Office.Tools.Excel.NamedRange namedRange2 =
        this.Controls.AddNamedRange(this.Range["C1", "C3"],
        "namedRange2");
    namedRange2.Value2 = 5;

    // Copy the contents of namedRange1 to the clipboard, and then 
    // paste the contents into namedRange2, adding each to 
    // the value in namedRange2.
    namedRange1.Copy();
    namedRange2.PasteSpecial(Excel.XlPasteType.xlPasteAll,
        Excel.XlPasteSpecialOperation.xlPasteSpecialOperationAdd,
        false,
        false);
}

.NET Framework Security

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace