Рет қаралды 42
VBA Range function allows up to 255 characters. If more Union (of ranges) is the function and that allows up to 30 arguments. Afterwards only to incremental increase of the argument can allow for more. Below is the piece of code that gets that done:
Dim RR As Range
For i = 0 To nrange
If i = 0 Then
Set RR = Range(v5(i))
Else
Set RR = Union(RR, Range(v5(i)))
End If
Next i
RR.Select
RR.Activate