I was just told (although not said exactly in those words),
it would be like re-inventing the wheel, but most of all that it
would slow the process so much.

And then I hear "what's the problem with slowing down?"
So I'll listen to everyone and make my own decisions, that will
depend on
1. how fast I can learn
2. what really makes a positive difference.

About long  formulas, there was a time when I had lots of "nested IFs"
(the max is seven effectively 7, at least in my 2002 version, I
needed 10, and each of the IFs was pretty long, this was ridiculous,
so I have changed the whole way I was doing to a much simpler formula.

Sometimes I do the reverse:
I had to extract a date recognizable by Excel as a date, from a very
long text string received by my Webquery.
There were so many things to consider: I wrote the process using many
different cells.
I had to redo it many time as the dates went on, until I saw it would
work for all dates.

[I find that Excel stings handling is not as good as in, let's say
Javascript.]

Now I could use all the formulas  from the different cells and produce
a very long single formula.
But this would be just making the whole more difficult for me to
read, if ever I had to redo it (I'll have too past 2009-12-31).

Those cells are beside a Web query that will not be seen anyway,
because, with the tips that I have received from this forum, the web
queries are now all in the same sheet that is hidden and protected,
when not used, and when used the screen is not updated.

As suggested by Jimmy, I am starting to rethink my worksheet  design,
as this project started much simpler, and grew a lot, as new ideas or
proposals kept coming in.
Now it's over, I do not add anything new, just make sure that this
one is pretty foolproof and works in all conditions, that change all
the time according to the results from the web queries

But as for my array that contains so many formulas not used, I
am not sure if you understood what my problem was.
If I can't find a solution by rethinking my design, (and after
consulting my dear new book thoroughly), I'll come back.

Lets's consider this topic closed, because we are really starting
to... get out of topic, which I usually hate on forums :-)