> So one in a while, I go over the formulas  that have been used
> and just keep track of previous downloaded data, and I copy
> paste them.
I'm so sorry Louise, I don't think I fully understand. I think I may have
the wrong end of the stick here.
... And who's stopping you from writing functions!??

I can't think of anything offhand that can be done with functions  that can't
be done in VBA. In fact there is a lot of VBA code out there that has been
written to "improve" some of the functions!

15 Secs ... Well... I dunno if that's such a big deal really. But you also
say you are using this as a learning experience. I'd try writing VBA to do
what you want without using worksheet  functions at all... Just VBA. It will
definately slow you down... at first... because of the learning curve.. But
the gain in expertise will be immeasurable.

What's the longest formula you have?
As I said previously, I've written VBA functions just to get screen space
back!

Long formulas can also be quite difficult to work through, for example when
there are lot of IFs... Actually, the IF nest limit, though there are
workarounds, was, I believe, 7 for MSO 2003... Anyone know if that's changed
in MSO 2007 or wether I have it wrong?