Adding a sheet reference to each range in a union

[Kaelen]

Hey all so I have a range object defined that was created from a union of a variable number of other range objects. This union is then supposed to go into a formula; however, the way I have it set up now the sheet reference only appears in front of the first range in the union. I need it to be in front of all of the ranges in the union. Here is the line of code.


Cells(3 + ((j - 1) * 2), 3 + (a * 5)).Formula = "=AVERAGE(" & allneck(j).Parent.name & "!" & allneck(j).Address & ")"

Thanks a lot.

 

[Norie]

Where's the range?

What's allneck(j)?

 

[Kaelen]

Sorry, "allneck" is a dynamic range variable.

I actually found a way to get around this problem by making allneck into a string variable. The loop that used to take each of the elements in another range variable called "neck" and union them into "allneck" now just concatenates their addresses into a single string instead.