Automation Error
 

Hi All,

I have a macro that helps me normalize the data in a input worksheet and
put it in a output worksheet. I use the Do Until Loop in the macro to
process all the data until all the data has been processed. It works fine,
but whenever i have more that 8193 rows of data, the following runtime error
will appear:

Run-time error '-2147417848 (80010108)'
Automation Error
The object involved has disconnected from its clients.

It will stop on the line that tells excel to hard code the data in the
output worksheet (within Do Until Loop):
Sheets("Output").Rows(Last).Copy
Sheets("Output").Rows(Last).PasteSpecial Paste:=xlValues

I would appriciate any help you can give me.

--
Regards,
Tim