strange 1004 error, cannot copy past 30 sheets

Hi,

I need to copy a certain sheet, serving as a template, as much as there are rows (about 380), so I created this VB script:

Please Login or Register  to view this content.

This works, but Excel stops at about 30 sheets and then gives the error:

Error 1004 while executing:

Method Copy from class Worksheet failed

This is translated from Dutch, so it might not be the exact error message

Any idea how to solve this? I've already granted Excel access rights to VB

Thanks Donkey,

this solved it.