LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Reference an Array to Count Values? Mashuganah Excel Discussion (Misc queries) 6 December 4th 09 04:33 PM
Cell reference within array [email protected] Excel Worksheet Functions 10 May 6th 09 02:52 PM
Reference array constant values in a formula notso Excel Discussion (Misc queries) 2 September 28th 08 11:34 PM
Retrieve variant array of cells as formatted in the cell R Avery Excel Programming 2 September 1st 04 05:06 PM
Find row with matching cell and retrieve values (VBA) John[_86_] Excel Programming 1 June 26th 04 01:43 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"