VBA - Excel Union Method: Setting Dynamic range
Posted on 2010-09-07
I'm stuck trying to figure out how to use the union method on a dynamic range array.
I have an range array for a number of banks which changes from period over period. Instead of using
Set rngUnion = Union(rngBank(1), rngBank(2), rngBank(3), etc)
is there a way to set the rngUnion to the bounds of the array?
Unless there's a Set Preserve, I can't think of a loop for this. Thanks guys!