Maybe soimething like

ReDim Preserve ary(UBound(ary) + 1)
ary(UBound(ary)) = "xyz"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"havocdragon" wrote in message
...
Hi all. Over the last month or so, I have familliarized myself (almost
painfully so) with utilizing arrays and loops together in my macros for
efficiency (and sanity).

What I am wondering, is how do you load an array dynamically?

I know well how to declare one such as

V = Array("stuff","morestuff") etc etc
However what if the contents of the array need to change on a weeky basis?
I
hate having to go in and reprogram it, and was wondering if there was a
way
to load it dynamically?