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.
I want to work with sArrPos1 first, then sArrPos2, then sArrPos3, but can't hard type them.![]()
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
Thanks,
Bookmarks