Try moving them in groups rather than one at a time.

If your moving that many sheets, it may be easier to copy them all, then
delete the ones you don't want, then delete the ones in the old workbook I
can't really say since I don't know exactly what you are about, but you want
to minimize the number of actions you take.

--
Regards,
Tom Ogilvy


"azurmendi" wrote in message
lkaboutsoftware.com...
Hello!!

Thanks very much for your suggestions.

My intention is to move a sheet from a Workbook to another workbook. Both
of them are unprotected.
And my problem is that the error grows when I move the 100 sheet.

Any idea?

Thanks in advance!!

Regards,
María