Copy sheets and rename from a list

**foneexcel** · 03-23-2009, 08:19 AM

Hi guys!

I need to create a macro that will do the following:
1. copy an already existing sheet (named: "master")
2. rename it with a name contained in a list (on sheet "list")
3. move the sheet at the end of the workbook
4. loop til the last value of the list

the macro should be launched several times and therefore should recognize already existing sheets avoiding duplicates

I tried the following code but it punctually stops after the 17th sheet instead of going to the end of the list (approx 30 values).
What's wrong?

Tx a lot for ur help!
Fone

Please Login or Register  to view this content.

**shg** · 03-23-2009, 08:25 AM

Welcome to the forum.

Please take a few minutes to read the forum rules, then edit your post to add code tags.

**ravishankar** · 03-23-2009, 08:58 AM

Hi
try the following codes (which worked for me upto 50 sheets)

Please Login or Register  to view this content.

Ravi

**foneexcel** · 03-23-2009, 11:23 AM

Hi ravi!

thanks a lot for ur suggestion ... unfortunately it keeps giving me the same error... it goes up to a random number of copies and then I get "run-time error 1004" copy method of worksheet class failed"

then if I try to re-launch the macro it doesn't work and goes into debug

can anyone help please?
thanks again
f

**foneexcel** · 03-23-2009, 11:39 AM

I got that the problem is the content of the sheet to be copied... it is a range of 25 column/100 rows of VLOOKUP.

Is there any way to create empty sheets - named on the basis of a list - and then copy and past the content of cells from a "master file" ?

thank you