OssieMac, thank you for the elementary explanation. The reason I'm
interested in arrays is I have many workbooks that copy and paste ranges
inside of loops, so the ranges change with each i, so the screen is jumping
all over the place, and it just looks bad. So, I am gathering that once I
Dim the array, say MyArray(), and I put it in a loop where for each i,
MyArray = SomeVariableRange, the values for the new range will overwrite the
existing values in the array from the previous i? I tried it out on a loop
that copies a solver solution range for 70 runs, and populates a report
section. The data seemed to be no different than if I had copied and pasted
the ranges. Am I missing something, or is this how they are supposed to
work? Thanks again.

Greg

"OssieMac" wrote:


Also Google (or other favourite search engine) "excel vba array tutorial"
and you should find some more info.


--
Regards,

OssieMac