Yeah, for what it's worth, I seldom use anything more than array formulas to
produce summaries very quickly...however, there has been some discussion in
the past (in this forum) that, depending upon what you are trying to
accomplish) ADO may have superior speed in very large spreadsheets (like 50k+
rows of data)...

"FSt1" wrote:

hi
if the sheets are in the same workbook, i see no reason to use ADO. a
regular sub should be sufficient. and if you are using formulas to summerize
the data, why complicate it with a lot of code unless the formulas are
lacking somehow. did you leave something out of your post?????
regards
FSt1

"todtown" wrote:

Here is an easy one for somebody. I have a workbook where one of the
worksheets contains columns of data and another worksheet is a summary
of that data. I can use formulas in the summary sheet. I can also use
something like EVALUATE(FORMULA) in VBA. But, is it possible to use
ADO to connect to the Data sheet and populate the Summary sheet using
queries against that data?

tod