You mean you want to fill a function into the range of cells? I think you
will have to open the file in Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ytayta555" wrote in message
...
On 21 Mar, 17:41, Dick Kusleika wrote:
What kind of data is in B91? Is it a number? A date? ADO can't do an
AutoFill, but you may be able to do something similar. Generally when you
use ADO to read or write to a closed workbook, the worksheet to which you
are writing is set up like a database table - that is, each row is like a
record and each column is a field.

In Range (B91:B65536) are 65446 Count function !!
can ADO do something similar AutoFill
Destination:=Range("B91:BB65536")?


Having said all that, I agree with everyone else who said this sounds like
a
bad idea. Dick Kusleika
Microsoft MVP-Excelhttp://www.dailydoseofexcel.com



I just try , and many thaks for help and sugestions