In VBA can I avoid "out of stack" error by using cells instead of arrays?

[tahi.laci]

I will have to work with a lot data (mostly integers, and some small strings). I estimate that I will need to store thousands or tens of thousands pieces of these bits of information. My question is whether I should store them in arrays or excel cells in order to avoid "out of stack" error.

As far as I understand stack is working memory, so the question could also be whether cell contents are stored there. (I have never got "out of stack" even when I used much more cells, that's why I think using cells is a solution)

Alternatively is there another place (like special type of arrays, or a program like notepad) where I can store the data without it using working memory? Preferably this other place would be faster to read/write than excel cells.

[Jakobshavn]

If you use cells rather than VBA arrays, you may avoid stack problems, but the code will run slower.

[shg]

Tens of thousands of items is no problem. Tens of millions might be a problem.