Worksheet.Paste 方法 (Excel)Worksheet.Paste method (Excel)

将“剪贴板”中的内容粘贴到工作表上。Pastes the contents of the Clipboard onto the sheet.

语法Syntax

表达式粘贴(目标链接)expression.Paste (Destination, Link)

_表达式_一个代表**工作表** 对象的变量。expression A variable that represents a Worksheet object.

参数Parameters

名称Name 必需/可选Required/Optional 数据类型Data type 说明Description
DestinationDestination 可选Optional VariantVariant 一个 Range 对象,指定用于粘贴剪贴板中内容的目标区域。A Range object that specifies where the Clipboard contents should be pasted. 如果省略此参数,则使用当前的选定区域。If this argument is omitted, the current selection is used. 只有在“剪贴板”中的内容可以粘贴到某个范围内时,才能指定此参数。This argument can be specified only if the contents of the Clipboard can be pasted into a range. 如果指定了此参数,则将不能使用 Link 参数。If this argument is specified, the Link argument cannot be used.
LinkLink 可选Optional VariantVariant 如果为 True,则建立指向粘贴数据来源的链接。True to establish a link to the source of the pasted data. 如果指定了此参数,则将不能使用 Destination 参数。If this argument is specified, the Destination argument cannot be used. 默认值为 FalseThe default value is False.

注解Remarks

如果不指定_destination_参数, 则必须先选择目标区域, 然后才能使用此方法。If you don't specify the Destination argument, you must select the destination range before you use this method.

该方法可能会修改工作表中的选中范围,这取决于“剪贴板”中的内容。This method may modify the sheet selection, depending on the contents of the Clipboard.

示例Example

此示例将工作表 Sheet1 上单元格 C1:C5 中的数据复制到单元格 D1:D5 中。This example copies data from cells C1:C5 on Sheet1 to cells D1:D5 on Sheet1.

Worksheets("Sheet1").Range("C1:C5").Copy 
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("D1:D5")

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.