Need to hold and anlyse data in "virtual" array

[Ochimus]

Never come across this before and no idea if anyone has done this?

End User wants Macro to download the date and a price from the net at each "month end", do some financial calculations on the cumulative data, and generate a graph from the results that can span a month to a year.

Which is straightforward.

The challenge is they do not want the data on a spreadsheet. They want to download the dates and prices into a "virtual" array on the PC, which the Code can interrogate and produce the graph.

All suggestions or solutions welcomed gratefully.

Ochimus

[shg]

You can put a set of data directly in the Series function for a graph, e.g.,

=SERIES(,{74,34,62,82,44,72,71,46,25,22,34,70,16,56,97,70,3,21,70,41,51,23,38,36,21,72,57,69,64,34,53,25,84,66,93,77,11,39,82,6,83,82,20,55,67,7,64,25,33,20,12,17,12,31,87,13,22,97,63,56,56,97,55,52,21,30,63,73,45}, {30,39,25,76,58,7,16,95,79,22,32,96,26,96,64,24,84,92,38,68,58,57,95,59,26,5,88,28,74,35,98,49,57,93,30,35,13,25,19,37,24,52,8,77,7,86,30,23,20,8,90,12,77,67,82,83,74,97,28,62,18,67,34,67,82,83,7,8,66},1)

I don't know what the limitation is for size.

[xladept]

Use VA as a Variant and assign it to your null worksheet range:

Dim VA:VA=Range("A1:Z94557")

Then instead of a designation like Cells(958,23) you can write VA(958,23)

[Ochimus]

Just returned home to find your two responses.

Many thanks for finding the time to offer the suggestions. I am still trying to work through this, and suspect I will be back asking for more clarification and support.

Ochimjus