excel - 可以合并两个范围吗？- VBA

Question

我通过在线获取以下错误来尝试在 VBA 中Union使用两个范围。有任何想法吗？UnionSet rngBothRanges = Union(rngControl, rngFinished)

代码：

Dim arrHeaders As Variant
Dim rngControl As Range
Dim rngFinished As Range
Dim rngBothRanges As Range

Set rngControl = wsControl.Range("A1")
Set rngFinished = wsFinished.Range("A1:H1")

Set rngBothRanges = Union(rngControl, rngFinished)

标签： excelvbarangeunion