getting this error on paste command that used to work
until i transformed the macro that used to process a
single workbook and stop running into a batch process that
updates workbooks in sequence
number: -2147417851
Method 'Paste' of object '_Worksheet' failed

there could be many things that cause that error I suspect. So just posting
the error message isn't going to be of much help in diagnosing the error.
Since you say it started when you changed the environment of the macro, I
would look at what the situation is when the error occurs. This look more
like a context problem than a syntax type problem.

--
Regards,
Tom Ogilvy

cp <(E-Mail Removed)> wrote in message
news:39d901c3aa50$d98ba8a0$(E-Mail Removed)...
> getting this error on paste command that used to work
> until i transformed the macro that used to process a
> single workbook and stop running into a batch process that
> updates workbooks in sequence
> number: -2147417851
> Method 'Paste' of object '_Worksheet' failed