Retrieve values from array and use as cell reference
The ancient memory banks are not firing well today!
I need to programmatically generate a range of address, store them in an
array and create a union of the addresses. Kind of as follows:
....
for i = 1 to 20
AddrList(i) = "A"&i
next i
....'more code
for i = lbound(AddrList) to Ubound(AddrList)
UnionRange = Union(UnionRange, AddrList(i))
next i
'more code
' Example additional code:
UnionRange.select
' more code
How do I pass my AddrList values to UnionRange in a way that Union()
understands that it is working on range addresses?
--
Stephen
Due to the volume of garbage I filter out googlegroups.
|