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