excel - 数组中的名称范围

Question

我有一个包含两个名称范围的变体变量。我尝试使用存储在变量中的范围名称来复制范围，但我不知道该怎么做。请看下面我的代码。有什么建议么？

Dim tbl2 As Range
Dim tablearray2 As Variant

Application.ScreenUpdating = False
Application.EnableEvents = False

tablearray2 = Worksheets("Sheet2").Range("C2:C3") **<--- Here i store the name of the ranges in the tablearray2 variable**

'The tablearray2 now contains the following values: Table1, Table2 which are the names of two different ranges.

Set tbl2 = tablearray2(2,1)

tbl2.copy

End Sub

谢谢您的帮助

标签： excelvba

Answer 1

这是一个小例子，包括粘贴位。

Sub x()

Dim tbl2 As Range
Dim tablearray2 As Variant

tablearray2 = Worksheets("Sheet2").Range("C2:C3")

Set tbl2 = Range(tablearray2(2, 1)) 'contents of C3 = "Table2"

tbl2.Copy Worksheets("Sheet2").Range("A5") 'paste range to A5

End Sub