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.
Cells(3 + ((j - 1) * 2), 3 + (a * 5)).Formula = "=AVERAGE(" & allneck(j).Parent.name & "!" & allneck(j).Address & ")"
Thanks a lot.