Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Reference an Array to Count Values? | Excel Discussion (Misc queries) | |||
Cell reference within array | Excel Worksheet Functions | |||
Reference array constant values in a formula | Excel Discussion (Misc queries) | |||
Retrieve variant array of cells as formatted in the cell | Excel Programming | |||
Find row with matching cell and retrieve values (VBA) | Excel Programming |