excel中vba将选择区域赋给变量

2025-02-27 23:37:38
推荐回答(2个)
回答1:

Sub Macro1()
Dim MyRange As Range '定义Range型的变量
Set MyRange = Range("A1:C3") '用Set命令将对象赋值给变量
MyRange.Copy

Cells(5, 1).Select '选中A5单元格
ActiveSheet.Paste '粘贴
End Sub

GoodLuck!

回答2:

Dim a As Variant
a = Range(