Suppose you have 3 variant Arrays, named sArrPos1, sArrPos2, and sArrPos3.
What is the syntax for using an integer variable to specify which of the three to work with?
e.g.
ReDim mArr(1 To 3)
mArr(1) = "D1"
mArr(2) = "C1"
mArr(3) = "B1"
ReDim fArr(1 To 3)
fArr(1) = "Too"
fArr(2) = "Wong"
fArr(3) = "Foo"
For i = 1 To 3
For j = 1 To 3
If sArrPos & i(1, j) = fArr(i) Then ???
Set rngDest = .Range(mArr(i))
Set rngDest = rngDest.Resize(UBound(sArrPos & i), 1) ???
rngDest.Value = sArrPos & i ???
End If
Next j
Next i
I want to work with sArrPos1 first, then sArrPos2, then sArrPos3, but can't hard type them.
Thanks,
Bookmarks