code tags would help us see the code blocks separate from your questions. Instructions for using code tags are in the forum rules link at the top of the page.
1) You look like you are trying to use the same variable for the range array and for the string index array. I would probably assign two different arrays for this.
2) You cannot use a variable in a dim statement to create a variable sized array. You accomplish this using a dynamic array with the Redim statement http://msdn.microsoft.com/en-us/libr.../gg251578.aspx But, it is not clear to me if you need a dynamic array. In this case, it looks more like you are trying to dim each element of array rA separately during each loop, which is not necessary. When an array is dimensioned, each element is also dimensioned, if that makes sense.
This might look something like
dim rA(2) as range
stindex=array("a","b","c")
for i=0 to 2
set ra(i)=sheets(1).range(stindex(i))
next i
Bookmarks