assistance on copy array sheet to a new workbook , excel crashes , get runtime error

[JEAN1972]

I used the code below to copy active workbook to a new workbook. It works fine .

But when I used the same as below in another workbook, my excel crashes .

Note I recieved a batch of workbook from same supplier with same format , only contents which changes .

Please Login or Register  to view this content.

I used another code

get runtime error 9, scriptt out of range

Please Login or Register  to view this content.

[Fluff13]

It looks like you have a space before page in the 3rd sheet name. Should that be there?

[JEAN1972]

Now it works as below, when module is the sheet to copy but when I moved acopy to my personel.xlb, it shows script out of range when applied

Please Login or Register  to view this content.

[Fluff13]

That's because you are referring to ThisWorkbook, which is the book that holds the macro. Try changing that to ActiveWorkbook

[sintek]

Jean...your code works fine...Look to see if the sheets actual names correspond to the names in the array.

[JEAN1972]

@Fluff & Sintek

Ok now, active workbook and space was the issues .

Thank you both for assistance

[Fluff13]

Glad we could help & thanks for the feedback