View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cawshus Cawshus is offline
external usenet poster
 
Posts: 9
Default 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.